One Diagram for MemSQL Rowstore and Columnstore Tables

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 · All drivers

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.

From Download to MemSQL ER Diagram

Because MemSQL speaks the MySQL protocol, the connection wizard needs only a handful of details.

1. Download and install DbSchema.
2. Create a new connection and select MySQL as the database type — DbSchema downloads the MySQL Connector/J driver automatically the first time it's needed.
3. Enter the aggregator node's host and port 3306, plus your username and password; the resulting URL is jdbc:mysql://host:3306/dbname.
4. Click connect. DbSchema reads the schema from the aggregator and renders the first ER diagram.

Always point the connection at an aggregator node rather than a leaf node — DDL executed directly on a leaf will not propagate across the cluster. Find the aggregator address in the MemSQL management console's cluster topology view. If your deployment uses a non-standard port, check the port setting in memsql.cnf before connecting.

Why Teams Use DbSchema for MemSQL Schemas

• 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.

Still running MemSQL under its original name? Download DbSchema and get a documented baseline of the schema before any move to SingleStore.

Related databases

Teams working with MemSQL often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases