Design and Manage SingleStore Databases with DbSchema
Build a clearer workflow for SingleStore: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See SingleStore Features Download SingleStore JDBC Driver
What happens after you download?
Get to your first SingleStore schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to SingleStore or open a sample
Reverse engineer an existing SingleStore database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Connecting DbSchema to SingleStore
SingleStore is MySQL-compatible and listens on port 3306 by default. Use the SingleStore JDBC driver
or the MySQL Connector/J driver — DbSchema can download either. The JDBC URL format is
jdbc:singlestore://host:3306/dbname for the native driver, or
jdbc:mysql://host:3306/dbname for Connector/J. For SingleStore Helios (cloud), copy the
workspace endpoint from the SingleStore portal and authenticate with workspace credentials. Workspace
group firewalls must allow inbound connections from your IP before DbSchema can connect.
Why Teams Use DbSchema with SingleStore
- 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.