SingleStore features in DbVisualizer.
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.
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.
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.
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.
Try DbVisualizer Pro
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.
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.
Users love using DbVisualizer.
-
Alberto DDirector 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 BProduction 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 JBusiness 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 DDirector 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 BProduction 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 JBusiness 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]()
Great feedback from great users.
DbVisualizer is a G2 Leader among database management software.
Frequently asked questions
- What is SingleStore?
SingleStore is a relational database management system.
- What is a SingleStore client?
To connect to and manage your SingleStore database, you use a SingleStore client.
- What is SingleStore database client used for?
To navigate and manage your SingleStore database, for example, insert, delete and update tables.
- How do I connect to SingleStore with DbVisualizer?
DbVisualizer has a driver manager built-in that you can use to connect to SingleStore. The driver manager is hosted on Maven and gives you a number of JDBC driver versions to choose from.
- How can I use DbVisualizer as a query tool?
The visual query builder in DbVisualizer automatically generates SQL code when you drag and drop tables and select your values. It also allows you to write SQL queries, highlighting operations and auto-complete suggestions done smartly.
- How do I get started to use SingleStore with DbVisualizer?
Download DbVisualizer, and connect to your SingleStore database. You can evaluate the Pro version for 21 days, or you can buy the Pro version to get the complete function set. You can also use the client for free with a limited function set.
- What are the benefits of using SingleStore?
SingleStore is a scalable, high-performing tool for complex SQL querying.
- Can I connect to SingleStore and other databases using DbVisualizer as a SingleStore client?
Yes, DbVisualizer can connect to many different data sources to browse and manage data. Several companies have many different databases, and with DbVisualizer, you get one tool to handle all (on this list) data sources.
- How can I connect to my database using the SingleStore JDBC driver?
You connect by using the built-in driver manager in DbVisualizer. Select SingleStore from the list of accessible data sources and enter your credentials; then, DbVisualizer automatically sets up the connection.
- What object types are supported in the DbVisualizer SingleStore client?
The majority of the object types for SingleStore are supported in DbVisualizer, and you can see the full list of supported object types here.
- What are some of the features of the SingleStore GUI in DbVisualizer?
DbVisualizer covers many intelligent features, for example, putting multiple SQL editors next to each other for easy comparisons, organizing tabs, saving scripts and working with variables, using the Auto-complete feature, and a lot more. DbVisualizer can easily be customized to match your way of working.
- What is the difference between a SingleStore client, a SingleStore GUI, a SingleStore IDE, a SingleStore editor, and a SingleStore workbench?
Many different labels mean more or less the same thing. The client implies that you have a server somewhere else, and the GUI refers to the graphical interface of the system. IDE means the larger "integrated development environment" and the editor refers to a specific part of the client where you write your code. While a workbench targets more on the process of development. All of these have become synonyms in how users refer to the application in which they do the SQL coding.
- Is there a database browser in DbVisualizer?
Yes, you can see the tables, relations, and custom objects for each database. DbVisualizer includes automatic visualization tools where you generate entity relationship diagrams (ERDs) or see the explain plan.