supabase-schema-catalog

Yes, you can generate SQL migrations offline by using the JSON catalog of your Supabase Postgres schema. The catalog stores table and column metadata, allowing AI agents to generate migrations, documentation, and mappings without live DB access.

Building a Supabase schema catalog requires a working SUPABASE_DB_URL environment variable, a read-only database user, and psql installed. You run the build_schema_catalog.sh script to produce the JSON output for your agents.

An offline Supabase schema catalog stores your Postgres table and column metadata in a portable JSON format. This allows AI agents and automation workflows to access schema structure for generating SQL and mapping data models without live queries.

To automate Supabase schema documentation, load the offline JSON catalog into your AI agent. The catalog contains the structural metadata needed to automatically generate documentation, verify schemas, and guide SQL generation without live database queries.

Generating the initial Supabase schema catalog requires a live database connection via the SUPABASE_DB_URL environment variable and a read-only database user. Once the JSON catalog is built, subsequent schema-aware automation requires no live database queries.

After building the Supabase schema catalog, use the JSON metadata to generate SQL migrations, map tables to domain entities across Odoo and analytics pipelines, document schemas, and drive schema-aware automation during feature rollouts or migrations.