Download the SingleStore JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.
A JDBC driver is a Java .jar library that lets applications connect to SingleStore.
DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation.
Driver files are usually published by the database vendor or an open-source project.
Host, port, database name, and SSL options are passed in a URL starting with jdbc:.
Each SingleStore driver uses its own syntax — see the connection details below.
SingleStore (formerly MemSQL) is a distributed SQL database designed for mixed OLTP and OLAP workloads at high speed. It uses a MySQL-compatible wire protocol and is deployed for real-time analytics, financial risk systems, and personalization engines that require sub-second query response at scale.
Download SingleStore JDBC Driver
The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager. SingleStore is wire-compatible with MySQL, so the MySQL Connector/J driver is used.
SingleStore uses the MySQL wire protocol, so DbSchema connects using the MySQL JDBC driver. Use DbSchema's ER diagrams to visualize SingleStore's rowstore and columnstore tables, and the Schema Synchronization to manage DDL migrations across SingleStore clusters.
Connect SingleStore, build your first ER diagram in minutes. No account required.
Get the SingleStore driver zip below and install DbSchema for Windows, macOS, or Linux.
In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.
Reverse engineer SingleStore, edit the model visually, and publish schema documentation.
After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.
Reverse engineer SingleStore into an interactive diagram and edit structures visually.
Run SQL with autocomplete or compose queries without writing every join by hand.
Export HTML docs your team can browse without installing DbSchema.
Connection tips, ports, SSL, and schema design workflows on the database landing page.
Other drivers teams often configure alongside SingleStore.
Teams working with SingleStore often use these engines too. Explore dedicated guides and JDBC setup for each.