Design and Manage SQL Server Databases Visually with DbSchema

DbSchema lets you design, manage, and document SQL Server 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 SQL Server 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 SQL Server JDBC Driver

Managing SQL Server Complexity Through Visual Tooling

Enterprise SQL Server deployments commonly involve dozens of schemas, cross-database references, synonyms, and linked servers. Navigating this structure through Object Explorer or raw T-SQL scripts scales poorly as the environment grows. DbSchema imports the full SQL Server catalog and lays it out as a navigable diagram — every schema, table, view, and relationship visible in one workspace, without opening a single system table.

ER Diagrams Spanning Multiple Schemas

DbSchema supports multi-schema SQL Server databases, allowing you to build diagrams that include objects from dbo, hr, sales, and any other schema in the same database. Color-code schema groups, filter by object type, and export diagrams to PDF or SVG for architecture reviews and DBA sign-off.

Creating a SQL Server ER diagram across multiple schemas in DbSchema

Browse and Filter Live Table Data

The data explorer provides a row-by-row view of SQL Server tables with column filtering, result pagination, and foreign key navigation between related rows. Use it during troubleshooting to inspect production data, or after a migration to confirm that records are present and correctly structured.

Browsing SQL Server table data in DbSchema's data explorer

Schema Diff Between SQL Server Instances

DbSchema's schema synchronization tool compares any two SQL Server instances — or a local design model against a live database — and produces a T-SQL migration script covering every structural difference. Each change is listed individually so you can selectively include or exclude it before executing the script on the target server.

Synchronizing schema between SQL Server instances in DbSchema

Connecting DbSchema to SQL Server

SQL Server listens on port 1433 by default — TCP/IP must be enabled in SQL Server Configuration Manager if it is not already active. The JDBC URL pattern is jdbc:sqlserver://host:1433;databaseName=dbname. For Windows Authentication, append ;integratedSecurity=true and ensure the mssql-jdbc_auth native DLL is on the system PATH. DbSchema supports both SQL Server Authentication and Windows Authentication modes, and downloads the Microsoft JDBC Driver for SQL Server automatically on first use.

Why DbSchema for SQL Server Environments

  • Visualize cross-schema relationships that are not visible in Object Explorer.
  • Generate T-SQL migration scripts from schema diffs without manual comparison.
  • Document multi-schema databases as HTML reports with embedded, zoomable diagrams.
  • Design schema changes offline and push them to a SQL Server instance after review.
  • Navigate table data and follow foreign key links without writing ad-hoc SELECT statements.