Design and Manage Mimer SQL Databases Visually with DbSchema

DbSchema lets you design, manage, and document Mimer SQL databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Mimer SQL database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Mimer SQL JDBC Driver

Standards-Compliant Schema Design with Mimer SQL and DbSchema

Mimer SQL is a highly standards-compliant relational database designed for ACID transactions, embedded deployment, and enterprise applications requiring strict SQL conformance. Developed by Mimer Information Technology, it is used in aerospace, automotive, and medical device industries where data integrity and SQL standard compliance are non-negotiable. DbSchema provides a visual schema designer for Mimer SQL databases and helps development teams document and maintain Mimer schemas with precision.

Visual Schema Designer for Mimer SQL

DbSchema connects to Mimer SQL via JDBC and builds an interactive entity-relationship diagram of your database schema. Tables, columns, primary keys, and foreign key constraints are all rendered on a navigable canvas, giving your team a shared visual reference for the data model across all environments.

Visualizing a Mimer SQL database schema as an ER diagram in DbSchema

SQL Editor Supporting Mimer SQL Standard Queries

DbSchema's SQL editor connects to Mimer SQL and supports its standards-compliant SQL dialect. Run queries, inspect data types, and execute DDL statements directly against your Mimer instance — useful for development teams that prefer a GUI over the Mimer BSQL command-line interface.

Running SQL queries against Mimer SQL in DbSchema's SQL editor

Schema Documentation for Compliance Audits

Mimer SQL's use in regulated industries makes accurate schema documentation critical. DbSchema generates detailed HTML documentation from the Mimer catalog, covering table structures, data types, constraints, and entity relationships — formatted to support compliance reviews and certification documentation without manual effort.

Auto-generated Mimer SQL schema documentation in DbSchema

Connecting DbSchema to Mimer SQL

Mimer SQL listens on port 1360 by default. The JDBC URL format is: jdbc:mimer://host:1360/dbname. The JDBC driver class is com.mimer.jdbc.Driver. Download the Mimer JDBC driver from the Mimer SQL developer page (developer.mimer.com) and add it to DbSchema using Connections > Manage Drivers. For remote connections, the Mimer SQL Server must have network access enabled in the MIMCONTROL configuration; local connections use a named pipe by default.

Why DbSchema for Mimer SQL

  • Visualize Mimer SQL schema structures with an interactive ER diagram
  • Generate schema documentation suitable for compliance and certification audits
  • Run SQL queries from a desktop client without the Mimer BSQL interface
  • Edit table structures and verify data model integrity visually before deployment
  • Compare Mimer schemas across development and production environments