Best Database Documentation Tools in 2026: Compared and Reviewed
For the person who has to hand a database schema to colleagues who never open a database client, and is choosing the tool that writes the documentation.
On this page
Your colleagues keep asking what a table holds or what a column means, and the answer is in a database they never open. A documentation tool reads the schema and writes it out as pages they can read in a browser. DbSchema writes that documentation as HTML5, PDF or Markdown, with the diagram and every table and column comment. It reads the schema from the database or from a model file, DbSchema's own copy of the schema.
The pages that rank for this search also name dbForge Documenter, Redgate SQL Doc, SchemaSpy, Dataedo, dbdocs.io, Navicat and MySQL Workbench. Some of them also list database clients such as DataGrip, DBeaver and HeidiSQL, which show a schema but write no documentation. Every vendor fact below comes from the vendor's own pages, read on 11 November 2026.
What the documentation holds, and where the descriptions live
Useful database documentation holds:
- a diagram of the tables and the foreign keys between them
- every table and column, with its data type and whether it can be NULL
- the primary keys, foreign keys, indexes and constraints
- a description of each table and of each column whose name doesn't explain it
- the date it was generated
Every tool on this page reads the tables, types and keys from the database itself. The descriptions are where the tools differ. In most databases, a table or a column can carry a comment, a description stored in the database. In PostgreSQL 18, you add one with COMMENT ON:
CREATE TABLE customers (
id integer PRIMARY KEY,
email text NOT NULL
);
COMMENT ON TABLE customers IS 'Everyone who created an account';
COMMENT ON COLUMN customers.email IS 'Login and contact address';
The comments are now part of the schema, so any tool that reads the schema can print them. This query reads the columns back with their comments:
SELECT column_name, data_type,
col_description('customers'::regclass, ordinal_position) AS description
FROM information_schema.columns
WHERE table_schema = current_schema() AND table_name = 'customers'
ORDER BY ordinal_position;
| column_name | data_type | description |
|---|---|---|
| id | integer | |
| text | Login and contact address |
MySQL keeps comments the same way, with a COMMENT clause on the table or column. SQL Server keeps descriptions as extended properties, name-value pairs attached to a table or column. A description kept in the database stays when you change documentation tools, because the next one reads the same comments. Some tools keep the descriptions somewhere else, in a text file or in a database of their own:
Database documentation tools compared
| Tool | Reads the schema from | Output | Databases | Edition or price with documentation |
|---|---|---|---|---|
| DbSchema | the database, or a .dbs model file | HTML5, PDF, Markdown | 100+ over JDBC | Pro; Community up to 12 tables per diagram |
| dbForge Documenter | the database | HTML, PDF, Markdown | MySQL and MariaDB, SQL Server, Oracle, one product each | from 69.95 USD a year for MySQL |
| Redgate SQL Doc | the database | HTML, PDF, Word, Markdown | SQL Server | 303 USD per user a year |
| SchemaSpy | the database, over JDBC | HTML site | any with a JDBC driver | free, LGPL-3.0 |
| Dataedo | the database, into its repository | web portal; HTML, PDF, Excel | relational, MongoDB, Snowflake, BigQuery and more | Essentials, 18,000 USD a year |
| dbdocs.io | a DBML file | hosted web page | PostgreSQL, MySQL, SQL Server, Snowflake, BigQuery through db2dbml | Free plan, up to 10 projects |
| Navicat | the database | PDF data dictionary | the engines of each Navicat product | Standard and Enterprise |
| MySQL Workbench | a Workbench model | HTML, text | MySQL | commercial editions |
Tools that generate documentation
DbSchema
DbSchema connects to the database, reverse-engineers the schema (reads its tables and keys into a diagram), and writes the documentation from that model:
- Connect to the database. DbSchema reads the tables, keys and existing comments.
- Double-click a table header on the diagram, type the description in the Comment tab, and press OK. While DbSchema is connected, OK also writes the comment to the database.
- Choose File → Export As... → HTML5/PDF Documentation, or press Ctrl+D.
- Type a Title, choose HTML5, PDF or Markdown under Format, and press Generate.
Generating the documentation only reads the model. The HTML5 documentation is one .html file that opens in any browser, with no server and no internet connection. It carries the diagram as a vector image, shows each comment when you point at a table or column, and has a search box for tables, columns and comments. Below the diagram, each table gets a card with its columns, indexes and foreign keys:
The site has samples of each format: the HTML5 page and the PDF. Markdown goes next to your code in a Git repository, with the diagram as an .svg image.
DbSchema checks the model after every change, in every edition. One of the checks flags a table with no comment. To refresh the documentation every night, generate it from a Groovy script.
DbSchema Pro documents any diagram. The free Community Edition documents a diagram of up to 12 tables, with "DbSchema Trial" across the diagram image. Saving the model to a file needs Pro as well.
dbForge Documenter
dbForge Documenter by Devart reads the database and writes HTML, PDF and Markdown. Each engine has its own product: one for MySQL and MariaDB, one for SQL Server and one for Oracle. You edit object descriptions in Documenter, and the SQL Server edition reads them from extended properties. A command-line interface runs the generation from a script or Windows Task Scheduler.
The MySQL product starts at 69.95 USD a year, and the SQL Server product at 189.95 USD a year. dbForge runs natively only on Windows; on Linux and macOS, the requirements page asks for CodeWeavers CrossOver.
Redgate SQL Doc
Redgate SQL Doc documents SQL Server databases as HTML, PDF, Word or Markdown files. You add descriptions in SQL Doc, and it keeps them as extended properties in the database. A one-year subscription costs 303 USD per user for one to four users, and the trial lasts 14 days.
SchemaSpy
SchemaSpy is a free command-line program under the LGPL-3.0 license. It needs Java and the JDBC driver of your database. SchemaSpy reads the schema and writes an HTML site with ER diagrams. It prints the comments it finds in the database, and an XML file can add comments where the database has none. The latest release on GitHub is 7.0.2, from September 2025.
Dataedo
Dataedo is a data catalog. It imports the schema into its own repository, a database that Dataedo manages, and keeps the descriptions there. Its Windows desktop app exports HTML, PDF and Excel, and its web portal serves the catalog to readers. Dataedo's list of database connectors includes MongoDB, Snowflake and BigQuery. Dataedo also keeps a business glossary, the definitions of business terms, and data lineage, which shows where each table's data comes from. The Essentials plan costs 18,000 USD a year. Each plan needs at least three editors, viewers are unlimited, and the trial lasts 14 days.
dbdocs.io
dbdocs.io publishes a web page from a DBML file, the text format of dbdiagram.io. The descriptions live in that file, next to your code. The db2dbml command writes the DBML from a PostgreSQL, MySQL, SQL Server, Snowflake or BigQuery database. On the pricing page, the Free plan publishes up to 10 projects without password protection, and Personal Pro costs 8 USD a month.
Navicat
Navicat's Data Dictionary writes a PDF that lists the database objects, laid out by a template that you can change. On the feature matrix, the Data Dictionary and its schedule are in the Standard and Enterprise editions, and not in the free Lite edition. Navicat runs on Windows, macOS and Linux.
MySQL Workbench
MySQL Workbench writes HTML or text reports from a Workbench model with DBDoc, its report generator. The MySQL Workbench manual says DBDoc "is only available in the MySQL Workbench Commercial Editions". Workbench covers MySQL only. MySQL's product page says that the new MySQL Workbench replaces the earlier releases, such as 8.0, which have reached end of life.
DbSchema documents MySQL as it documents any other database: up to 12 tables per diagram in the free Community Edition, and any diagram in DbSchema Pro.
Database clients that show a schema without documenting it
A database client shows the schema to someone who has it open. Each of the clients below draws a diagram and exports data, but none writes documentation of the schema.
DataGrip
DataGrip by JetBrains is free for non-commercial use, and commercial use needs a subscription. It exports a diagram as a PNG image, or as a file for yEd, draw.io, Graphviz, Mermaid or PlantUML. With a non-commercial license, the data-sharing consent cannot be switched off.
DBeaver
DBeaver Community is free under the Apache 2.0 license. It draws an ER diagram from a live connection and saves it as PNG, GIF, BMP or GraphML, with SVG in the paid editions. On the editions page, Lite costs 113 USD a year, Enterprise 255 USD and Ultimate 510 USD.
HeidiSQL
HeidiSQL is a free client for MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, among others. It runs on Windows, Linux and macOS, with a portable build for Windows. It exports table rows as HTML, Markdown and other formats, and the database as an SQL script.
Document your own schema
Download DbSchema and connect it to the database that your colleagues keep asking about. Type a comment on the tables that need one, then export the HTML5 documentation and send them the file. The free Community Edition connects, reverse-engineers and documents a diagram of up to 12 tables. DbSchema Pro documents any diagram and saves the model to a file, and the download starts with a 15-day trial of every paid feature.
Sources
- DbSchema: schema documentation
- DbSchema: model validation
- DbSchema: automation scripts
- Microsoft: sp_addextendedproperty
- dbForge Documenter for MySQL
- dbForge Documenter for SQL Server
- dbForge Documenter for Oracle
- dbForge Documenter for MySQL: requirements
- Redgate SQL Doc
- SchemaSpy on GitHub
- Dataedo pricing
- Dataedo Desktop
- Dataedo: databases
- dbdocs.io
- dbdocs: generate DBML from a database
- dbdiagram.io and dbdocs pricing
- Navicat Premium feature matrix
- Navicat: create a data dictionary in Navicat 17
- MySQL Workbench manual: DBDoc
- MySQL Workbench
- DataGrip: diagrams
- DataGrip: usage statistics
- DBeaver: ER diagrams
- DBeaver editions
- HeidiSQL
Generate documentation from your own schema
DbSchema reverse-engineers the database into a diagram and exports HTML5, PDF and Markdown documentation from the same model. The free Community Edition documents a diagram of up to 12 tables; DbSchema Pro documents any diagram.