Turn Your Amazon Athena Catalog Into an ER Diagram

Athena queries files in S3 where they sit, with the AWS Glue Data Catalog as its only schema. DbSchema connects through the Athena JDBC driver and turns those cataloged tables into ER diagrams, visual queries, and documentation.

See every Glue database and table on one navigable diagram
Compose Presto-compatible queries visually and read the SQL first
Sample Parquet, ORC, and CSV-backed tables without the Athena console
Publish the lake schema for readers who have no AWS access

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema rendering Amazon Athena Glue catalog tables as an ER diagram

Trusted by teams at

The Schema Lives in the Glue Catalog
Where Your Team Can't Browse It

With Athena there is no cluster to introspect: the "database" is a set of Glue entries pointing at S3 paths and file formats. Answering "what tables do we have, and how do they relate?" means clicking through console pages or scripting the Glue API.

DbSchema reads the catalog once and lays it out as a diagram — the data lake, browsable like an ordinary database.

Explore, Query & Share
the Data Lake From Your Desktop

Catalog browsing, visual queries, and shareable documentation for S3-backed tables.

Reverse engineer the AWS Glue Data Catalog into an ER diagram

Map the Catalog in One Connect

DbSchema queries the Glue Data Catalog and diagrams every discovered database and table — column names, types, and structure — replacing console page-flipping with one picture.

Build Amazon Athena queries visually in DbSchema

Assemble Athena SQL Without Typing It

Drag catalog tables together, add joins and filters, and review the generated Presto-compatible SQL before Athena runs it — and bills for the scan.

Generate HTML documentation of an Amazon Athena data lake schema

Give Data Consumers a Catalog They Can Read

Export the Glue schema as HTML documentation with embedded diagrams — analysts and stakeholders browse the lake's structure with no IAM user and no console login.

A Data Lake Schema
With a Commit History

The model DbSchema builds from the catalog is a file. Commit it beside your ETL code, refresh it after each crawler run, and the diff shows exactly which tables and columns appeared — schema evolution your team reviews instead of discovers.

Amazon Athena schema model versioned in Git with DbSchema

Read Git Workflow Docs

Connect to Athena With the Simba Driver

Download the Simba Athena JDBC driver from the AWS documentation and register it in DbSchema's driver manager. The URL follows jdbc:awsathena://AwsRegion=us-east-1;S3OutputLocation=s3://bucket/prefix/ — adjust region and output bucket to your account. Authenticate with an IAM access key pair in the connection dialog, or let the AWS default credentials chain on your machine handle it. The IAM principal needs athena:StartQueryExecution plus s3:PutObject on the output bucket; without write access there, every query fails at execution time.