Download SingleStore JDBC Driver

Download the SingleStore JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the SingleStore JDBC driver

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.

JDBC URL format

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.

The SingleStore JDBC driver

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.

The SingleStore JDBC URL

• Required File(s): mysql-connector-java-nn-bin.jar
• Java Driver Class: com.mysql.jdbc.Driver
• JDBC URL: jdbc:mysql://HOST[:PORT][/DB]
• Website: SingleStore

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.

Connecting to a SingleStore Cluster

Clients connect to an aggregator, never to a leaf node. Port 3306 carries both your queries and the cluster's own traffic between nodes.

1. Point the host at an aggregator. The master aggregator answers DDL and queries; child aggregators answer queries. A leaf node refuses ordinary client work, so a connection aimed at one goes nowhere useful.
2. Grant the user access from your host. SingleStore keeps MySQL's user-plus-host accounts, so a user created as bar@'localhost' cannot connect from your machine. Grant the client address explicitly.
3. Open port 3306 in the server's firewall. The database listens on port 3306 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
4. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

Open 3306 narrowly. SingleStore uses the same port between its own nodes, so a rule written for the whole internet exposes the cluster's internal traffic as well as your client.

SingleStore Helios

On the managed service the workspace console holds the endpoint, and access is governed by an allowlist rather than by a firewall you run. Add your IP address there, then paste the endpoint into DbSchema. A BYOC deployment additionally needs TCP 3306 and 443 opened in its security groups.

DbSchema and SingleStore

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.