SingleStore client

SingleStore features in DbVisualizer.

SingleStore client
SingleStore client
DbVisualizer is #1 in user satisfaction on the G2 list of database management systems.
SingleStore G2 badge
SingleStore client

A feature-packed SingleStore client

The editor contains everything you need to connect, develop and manage your SingleStore database. It supports SingleStore-specific object types and a lot more that makes SingleStore a great database.

Work with SingleStore's specific object types

Object types

SingleStore supports various object types like Schemas and Tables, and also object types that are less common like TempTable, Pipelines and Pipelines. In DbVisualizer, you can easily explore and manage all objects in your database, just as intended by the SingleStore designers.

Object type actions

Actions can be generated via simple SQL queries or by right-clicking on the object and selecting the preferred action. Each object type has a purpose to be used in a specific way. The SingleStore client, DbVisualizer supports the execution of explicit actions for the object types in SingleStore.

Learn more about what object types are supported for SingleStore.

SingleStore object types

Get the most out of the SingleStore SQL editor

Auto-complete

Writing SQL for SingleStore is similar to writing SQL in other databases. DbVisualizer understands the differences and present relevant suggestions, allowing you to create better SQL queries more efficiently.

SQL formatting

The SingleStore editor automatically format your long unformatted SQL queries for easy editing.

Variables

Some queries are designed to be run several times, only changing minor details. The client-side variables for SingleStore can be used to bring up a dialogue, as a script run, letting the user to insert only these specific values. This removes the need for any edits to the query itself and it saves a lot of time.

Learn more about the supported features for SingleStore.

SingleStore autocomplete

Automatically visualize relationships and dependencies.

Generate Entity Relationship Diagrams (ERDs)

The relationships between the objects in SingleStore are important to understand. With DbVisualizer you can automatically generate ERDs and you ll be able to see all dependencies and opportunities directly in the SingleStore client.

ERD SingleStore
See the ERD feature
SingleStore ERD illustration

Explain plans

By extracting the explain plan for your query you can see how the database handles the request. This will allow you to explore ways to enhance the query so that it is efficiently executed by the server.

SingleStore ERD illustration

Try DbVisualizer Pro

Start your free 21 day evaluation of DbVisualizer Pro
Maven SingleStore driver

SingleStore JDBC driver management

The latest JDBC driver, and older versions, for SingleStore is built right in DbVisualizer. With the JDBC driver manager it is easy to connect your databases using JDBC drivers hosted on Maven, with several versions to choose from.

Maven SingleStore driver
SingleStore driver manager

Configure the SingleStore client

Set the properties for the SingleStore client to work the way want it to. The properties pane is used to configure your settings. This is where you make sure that the user have to enter a User-ID and password to access the IDE, enabling of pre-processing scripts. You can set up auto-commit and a lot more.

SingleStore properties

Users love using DbVisualizer.

  • Alberto D
    Director of Software Development & Integration

    DbVisualizer is attractive, complete and free software. Of course I would recommend it, since it is not very common to find programs as good as this one.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Matthew B
    Production Architect

    DbVisualizer allows me to connect to all of the databases I use with one tool and to work with them efficiently both from a development and operations perspective.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Elisabeth J
    Business Analyst

    I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it.
    Verified DbVisualizer user.
    Review from Capterra.
    capterra review
  • Alberto D
    Director of Software Development & Integration

    DbVisualizer is attractive, complete and free software. Of course I would recommend it, since it is not very common to find programs as good as this one.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Matthew B
    Production Architect

    DbVisualizer allows me to connect to all of the databases I use with one tool and to work with them efficiently both from a development and operations perspective.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Elisabeth J
    Business Analyst

    I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it.
    Verified DbVisualizer user.
    Review from Capterra.
    capterra review
/* g2 reviews */

Great feedback from great users.

DbVisualizer is a G2 Leader among database management software.

G2 badge
G2 badge
G2 badge
G2 badge
G2 badge
G2 badge
G2 badge
G2 badge

Frequently asked questions