Bring in your first schema

1. Run the metadata query

In the editor, open Import → PostgreSQL metadata query. Copy and run the query in your own SQL tool, then copy the schema_studio JSON result. Only tables you can SELECT are collected.

2. Select your tables

Paste the result into the JSON tab, validate it, and select the tables you need. Up to 100 tables and 2MiB of JSON are supported. Unsupported definitions are shown as warnings.

3. Explore and keep your work

Explore relationships and add display names and descriptions. Edits are autosaved locally; cloud storage updates only when you save explicitly. JSON preserves the full document, PNG helps you explain it, and supported SQL DDL can be exported for review.

Current scope

The metadata query targets PostgreSQL 16/17. Full metadata regression coverage currently runs on PGlite PostgreSQL 18.3; complete 16/17 server verification is pending. SQL DDL import, MySQL and real-time co-editing are not available yet.