Supabase Schema Tool

PostgreSQL & Supabase Schema Organizer

Supabase Schema Tool is a lightweight command-line utility that takes a PostgreSQL or Supabase SQL schema dump file and automatically organizes it into clean, dedicated folders for tables, functions, views, indexes, RLS policies, triggers, types, and extensions.

Features

• Automatic Classification — Sorts tables, functions, views, indexes, RLS policies, triggers, types, and extensions into dedicated subdirectories.
• Table Statement Merging — Automatically pairs ALTER TABLE statements with their parent CREATE TABLE definitions.
• Metadata Generation — Creates a machine-readable manifest.json and an auto-generated summary README.md.
• Safe & Non-Destructive — Extracts database objects verbatim without altering or inventing SQL statements.

Installation

Install globally via npm:

npm install -g supabase-schema-tool

Or run directly using npx:

npx supabase-schema-tool schema.sql

Usage & Commands

# Organize SQL schema into default ./schema_output directory
split-schema schema.sql

# Specify a custom output directory
split-schema schema.sql --output ./database
split-schema schema.sql -o ./database

# Enable verbose debug logging
split-schema schema.sql --verbose

# Display help information
split-schema --help
split-schema -h

# Display version number
split-schema --version
split-schema -v

Note: You can also run commands using supabase-schema-tool or npx supabase-schema-tool.

Output Structure

schema_output/
├── tables/          # CREATE TABLE + ALTER TABLE statements
├── functions/       # CREATE FUNCTION / PROCEDURE statements
├── views/           # CREATE VIEW / MATERIALIZED VIEW statements
├── indexes/         # CREATE INDEX statements
├── policies/        # CREATE POLICY statements
├── triggers/        # CREATE TRIGGER statements
├── types/           # CREATE TYPE statements
├── extensions/      # CREATE EXTENSION statements
├── misc.sql         # All other statements (SET, GRANT, REVOKE, COMMENT, etc.)
├── manifest.json    # Generation metadata
└── README.md        # Summary report

Supported Input

• PostgreSQL schema exports (pg_dump)
• Supabase CLI schema exports (supabase db dump)
• Any valid PostgreSQL DDL .sql file

License

MIT License