Design and Manage MemSQL Databases with DbSchema
Build a clearer workflow for MemSQL: 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 MemSQL Features Download MemSQL JDBC Driver
What happens after you download?
Get to your first MemSQL 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 MemSQL or open a sample
Reverse engineer an existing MemSQL 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.
MemSQL (rebranded as SingleStore) pioneered the concept of in-memory distributed SQL by combining a lock-free skip-list rowstore for low-latency transactions with a compressed columnar store for analytical aggregations. Its architecture separates aggregator nodes — which handle query planning and distribution — from leaf nodes that own partitions of the data. DbSchema connects to MemSQL via its MySQL-compatible JDBC interface, introspects the schema from the aggregator, and renders the dual-storage table model visually.
SQL Editor for MemSQL In-Memory Queries
DbSchema's SQL editor connects to a MemSQL aggregator and supports the MemSQL SQL dialect, including
USING CLUSTERED COLUMNSTORE, SHARD KEY, and stored procedure syntax.
The editor provides syntax highlighting, result set pagination, and the ability to save frequently
used queries as named snippets.
Download DbSchema Free See MemSQL Features
Data Explorer for MemSQL Rowstore and Columnstore Tables
The data explorer lets you browse MemSQL table contents without writing SQL. You can filter rows by column value, inspect columnstore tables that hold aggregated analytical data, and paginate through results — all from a graphical interface that does not require knowing the table's shard topology.
Schema Documentation for MemSQL Deployments
DbSchema generates HTML schema documentation from the MemSQL information schema, including ER diagrams that distinguish columnstore and rowstore tables, column definitions, and index structures. For teams transitioning from MemSQL to its successor SingleStore, this documentation provides a baseline record of the original schema before migration.
Connecting DbSchema to MemSQL
MemSQL is MySQL-compatible and listens on port 3306. DbSchema uses the MySQL Connector/J driver,
which it downloads automatically. The JDBC URL format is
jdbc:mysql://host:3306/dbname. Always connect to an aggregator node rather than a
leaf node — DDL statements executed on a leaf node will not propagate to the rest of the cluster.
The aggregator address is displayed in the MemSQL management console under the cluster topology
view. If your MemSQL deployment uses custom ports, check the memsql.cnf configuration
for the port setting.
Why Teams Use DbSchema with MemSQL
- Dual-storage visibility — visualize rowstore and columnstore tables in the same ER diagram with explicit type context.
- Aggregator-aware connection — DbSchema connects to the aggregator node for correct DDL propagation across the cluster.
- Migration baseline — document the existing MemSQL schema in full before migrating to SingleStore or another platform.
- Schema diffing — compare MemSQL schemas across environments and generate MySQL-compatible migration scripts.
- Data inspection — browse in-memory table contents from the data explorer without direct shell access.