One Diagram for SingleStore's Rowstore and Columnstore Tables

DbSchema gives SingleStore teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See SingleStore Features Download SingleStore JDBC Driver · All drivers

SingleStore is a distributed relational database built for hybrid transactional and analytical processing (HTAP). It stores data in either rowstore tables — optimized for point lookups and low-latency writes — or columnstore tables — optimized for analytical scans and aggregations — and allows both types to coexist in the same database. DbSchema connects to SingleStore, renders the schema with storage type annotations visible, and provides SQL tooling for both transactional and analytical query workloads.

SQL Editor for SingleStore HTAP Workloads

The DbSchema SQL editor connects to SingleStore and supports the full SingleStore SQL dialect, including AGGREGATION KEY, SHARD KEY, and SORT KEY clauses. Multiple tabs let you run transactional queries against rowstore tables and analytical queries against columnstore tables side by side, without switching tools.

Download DbSchema Free See SingleStore Features

Interactive Data Explorer for Real-Time Analytics

DbSchema's data explorer lets you browse table contents row by row, apply column filters, and paginate through large result sets without writing SQL. For SingleStore columnstore tables holding millions of analytical rows, this provides a fast way to inspect the data distribution and verify that ingestion pipelines are producing the expected output.

Schema Synchronization Across SingleStore Environments

SingleStore deployments typically span self-managed clusters and cloud workspaces. DbSchema connects to two SingleStore instances, compares their schemas, and generates migration DDL that handles differences in table storage types, shard keys, and column definitions. You review the proposed changes before executing anything against the target cluster.

Design a SingleStore Connection in DbSchema

SingleStore's MySQL compatibility means the connection setup is quick:

1. Install DbSchema — the download needs no account.
2. Create a connection and select SingleStore; DbSchema can download either the native SingleStore JDBC driver or the MySQL Connector/J driver.
3. Enter host and port — 3306 by default — forming jdbc:singlestore://host:3306/dbname for the native driver, or jdbc:mysql://host:3306/dbname for Connector/J.
4. For SingleStore Helios (cloud), paste the workspace endpoint from the SingleStore portal instead of a self-managed host, and authenticate with workspace credentials.
5. Connect, and DbSchema renders rowstore and columnstore tables together on the diagram.

Workspace group firewalls must allow inbound connections from your IP address before DbSchema can reach a Helios workspace.

Where DbSchema Fits Into a SingleStore Workflow

• HTAP schema visualization — see rowstore and columnstore tables together in the same ER diagram with storage type context.
• Shard key documentation — capture shard and sort key definitions in the schema model for distribution planning.
• Real-time data browsing — explore live analytical data in columnstore tables directly from the data explorer.
• Cross-environment diff — compare on-premises and Helios cloud schemas and generate targeted migration DDL.
• SQL testing — develop and test analytical queries in the SQL editor before embedding them in application code.

See your rowstore and columnstore tables on one diagram — download DbSchema for free, then link it up to your SingleStore workspace in a few minutes.