# pgschema, Declarative Schema Migration for Postgres

## Docs

- [Direct CLI demo with Manus and asciinema](https://www.pgschema.com/blog/demo-with-manus-and-asciinema.md): Using Manus AI agent to script and record a polished CLI demo with asciinema, complete with human-like typing and proper pauses.
- [pgschema: Postgres Declarative Schema Migration, like Terraform](https://www.pgschema.com/blog/pgschema-postgres-declarative-schema-migration-like-terraform.md): Introducing pgschema, a declarative schema migration tool for PostgreSQL with Terraform-style plan-review-apply workflow, no migration table, and comprehensive support for all schema objects.
- [Supabase Declarative Schema vs pgschema](https://www.pgschema.com/blog/supabase-declarative-schema-vs-pgschema.md): Comparing two declarative PostgreSQL schema tools: workflow differences, database object support, online DDL, CI/CD integration, and file organization.
- [Apply](https://www.pgschema.com/cli/apply.md)
- [dotenv (.env)](https://www.pgschema.com/cli/dotenv.md)
- [Dump](https://www.pgschema.com/cli/dump.md)
- [Ignore (.pgschemaignore)](https://www.pgschema.com/cli/ignore.md)
- [Plan](https://www.pgschema.com/cli/plan.md)
- [External Plan Database](https://www.pgschema.com/cli/plan-db.md)
- [For Coding Agent](https://www.pgschema.com/coding-agent.md)
- [FAQ](https://www.pgschema.com/faq.md)
- [Introduction](https://www.pgschema.com/index.md): Declarative schema migration for Postgres
- [Installation](https://www.pgschema.com/installation.md)
- [Quickstart](https://www.pgschema.com/quickstart.md)
- [ALTER DEFAULT PRIVILEGES](https://www.pgschema.com/syntax/alter_default_privileges.md)
- [COMMENT ON](https://www.pgschema.com/syntax/comment_on.md)
- [CREATE DOMAIN](https://www.pgschema.com/syntax/create_domain.md)
- [CREATE FUNCTION](https://www.pgschema.com/syntax/create_function.md)
- [CREATE INDEX](https://www.pgschema.com/syntax/create_index.md)
- [CREATE MATERIALIZED VIEW](https://www.pgschema.com/syntax/create_materialized_view.md)
- [CREATE POLICY](https://www.pgschema.com/syntax/create_policy.md)
- [CREATE PROCEDURE](https://www.pgschema.com/syntax/create_procedure.md)
- [CREATE SEQUENCE](https://www.pgschema.com/syntax/create_sequence.md)
- [CREATE TABLE](https://www.pgschema.com/syntax/create_table.md)
- [CREATE TRIGGER](https://www.pgschema.com/syntax/create_trigger.md)
- [CREATE TYPE](https://www.pgschema.com/syntax/create_type.md)
- [CREATE VIEW](https://www.pgschema.com/syntax/create_view.md)
- [GRANT / REVOKE](https://www.pgschema.com/syntax/grant_revoke.md)
- [Unsupported](https://www.pgschema.com/syntax/unsupported.md)
- [GitOps](https://www.pgschema.com/workflow/gitops.md)
- [Local to Production](https://www.pgschema.com/workflow/local-to-production.md)
- [Modular Schema Files](https://www.pgschema.com/workflow/modular-schema-files.md)
- [Online DDL](https://www.pgschema.com/workflow/online-ddl.md)
- [Work with ORM](https://www.pgschema.com/workflow/orm.md)
- [Plan, Review, Apply](https://www.pgschema.com/workflow/plan-review-apply.md)
- [Rollback](https://www.pgschema.com/workflow/rollback.md)
- [Tenant Schema Reconciliation](https://www.pgschema.com/workflow/tenant-schema.md)


Built with [Mintlify](https://mintlify.com).