pgschema
AGENTS.md1.1k starsChanged 9 months agoApache-2.0View on GitHub
These instructions are for AI assistants working in this project. Use the /trellis:start command when starting a new session to: - Initialize your developer identity - Understand current project context - Read relevant guidelines Use @/.trellis/ to learn: - Development workflow (workflow.md) - Project structure guidelines (spec/) - Developer workspace (workspace/) Keep this managed block so 'trellis update' can refresh the instructions.
1 other project uses a version of this.
Trending
Quiet since August.about the whole repository
Most recently taken up by
- pgplex/pgschemaword for word, first seen Oct 8, 2026
Who's talking about pgschema/pgschema
- @golangch.bsky.social“A Go-based CLI tool that brings #terraform - style declarative schema migration workflow to Postgres …”Bluesky · Sep 16, 2025 · 4 likes
- A Hacker News story“Pgschema: Terraform-style, declarative schema migration for Postgres”Hacker News · Sep 13, 2025 · 3 points
- pgplex/pgschema“📕 Guide: How to Migrate from Supabase to pgschema”GitHub · Jan 6, 2026 · 2 reactions
- pgplex/pgschema“feat: support PG 18”GitHub · Dec 3, 2025 · 2 reactions
- pgplex/pgschema“Brew install broken as of version 1.4.2”GitHub · Nov 25, 2025 · 1 reactions
The biggest 5 of 48 mentions linking to the repository that our crawl found. Each line is their own headline.
See all 48
Talked about on GitHub, Hacker News and Bluesky (48 times).
On GitHub · 45
- Jan 6, 2026📕 Guide: How to Migrate from Supabase to pgschema — pgplex/pgschema2 reactions
- Dec 3, 2025feat: support PG 18 — pgplex/pgschema2 reactions
- Nov 25, 2025Brew install broken as of version 1.4.2 — pgplex/pgschema1 reaction · 1 comment
- Nov 14, 2025chore: refine custom array type fix — pgplex/pgschema1 reaction
- Sep 13, 2025fix: constraint multi-column ordering — pgplex/pgschema1 reaction · 1 comment
40 more on GitHub
- Aug 21, 2026ci: retry the pgschema download instead of failing the schema step — AI-Native-Ventures/Colony0 reactions
- Jan 5, 2026feat: support GRANT/REVOKE for schema objects — pgplex/pgschema0 reactions
- Dec 18, 2025Fix array type handling in IsTextLikeType for USING clause generation — pgplex/pgschema0 reactions · 2 comments
- Dec 18, 2025Add unit tests for topologicallySortTypes function — pgplex/pgschema0 reactions
- Dec 18, 2025fix: type topological sort — pgplex/pgschema0 reactions · 2 comments
- Dec 17, 2025fix: partial index — pgplex/pgschema0 reactions
- Dec 17, 2025fix: generated column on public schema — pgplex/pgschema0 reactions
- Dec 5, 2025fix: support overloaded functions and procedures in dump (#191) — pgplex/pgschema0 reactions
- Dec 3, 2025fix: materialized view drop order that depends on table — pgplex/pgschema0 reactions
- Dec 2, 2025chore: generated_column test case — pgplex/pgschema0 reactions
- Dec 2, 2025chore: refine quotation — pgplex/pgschema0 reactions · 1 comment
- Nov 28, 2025fix: track LEAKPROOF and SECURITY DEFINER — pgplex/pgschema0 reactions
- Nov 27, 2025Add `limit` to missing "smart-quote" Keywords — pgplex/pgschema0 reactions
- Nov 27, 2025fix: default column value function order — pgplex/pgschema0 reactions
- Nov 24, 2025fix: preserve constraints to ignored tables in multi-file dumps — pgplex/pgschema0 reactions
- Nov 16, 2025fix: constraint name quoting — pgplex/pgschema0 reactions
- Nov 11, 2025chore: address review comments — pgplex/pgschema0 reactions
- Nov 9, 2025fix: normalize schema qualifier in function arguments — pgplex/pgschema0 reactions · 1 comment
- Nov 8, 2025chore: enhance plan schema name replacer — pgplex/pgschema0 reactions · 1 comment
- Nov 8, 2025Fix dependency handling: FK ordering, schema normalization, and function replacements — pgplex/pgschema0 reactions · 2 comments
- Nov 7, 2025fix: drop trigger/function order — pgplex/pgschema0 reactions
- Nov 7, 2025chore: log sql statement when apply/plan when —debug — pgplex/pgschema0 reactions
- Nov 7, 2025fix: type/extension from different schema — pgplex/pgschema0 reactions
- Nov 7, 2025Revert "fix: extension qualifier (#146)" — pgplex/pgschema0 reactions
- Nov 6, 2025fix: extension qualifier — pgplex/pgschema0 reactions
- Nov 5, 2025fix: non-primitive types qualified — pgplex/pgschema0 reactions
- Nov 1, 2025chore: consolidate DSN construction — pgplex/pgschema0 reactions
- Oct 31, 2025chore: add dump test case to verify index sorted order — pgplex/pgschema0 reactions
- Oct 31, 2025fix: index operators — pgplex/pgschema0 reactions
- Oct 30, 2025feat: add plan db option to apply command --file mode — pgplex/pgschema0 reactions
- Oct 29, 2025Fail to install when using `go get -tool` — pgplex/pgschema0 reactions · 2 comments
- Oct 27, 2025fix: function dump default — pgplex/pgschema0 reactions
- Oct 24, 2025fix: schema qualifer reference — pgplex/pgschema0 reactions
- Oct 23, 2025cross schema foreign key constraints introduce errors in planning — pgplex/pgschema0 reactions · 2 comments
- Oct 23, 2025chore: add NULLIF test case — pgplex/pgschema0 reactions
- Oct 13, 2025Add SSLMode connection option — pgplex/pgschema0 reactions · 3 comments
- Oct 2, 2025[Compatibility]: PgSchema is not working with Cedardb — cedardb/issues0 reactions
- Oct 2, 2025[Compatibility]: PgSchema is not working with Cedardb — cedardb/issues0 reactions
- Sep 19, 2025Support Windows installation — pgplex/pgschema0 reactions · 7 comments
- Sep 12, 2025Revert "fix: preserve column order in UNIQUE constraints (#17)" — pgplex/pgschema0 reactions · 7 comments
On Hacker News · 2
- Sep 13, 2025Pgschema: Terraform-style, declarative schema migration for Postgres3 points
- Sep 25, 2025Pgschema,a CLI tool for declarative schema migration workflow to PG1 point
On Bluesky · 1
- Sep 16, 2025A Go-based CLI tool that brings #terraform - style declarative schema migration workflow to Postgres #golang github.com/pgschema/pg... — @golangch.bsky.social4 likes and reposts
Other versions1 project uses a version of this.
Word for word · 1
- pgplex/pgschema★ 1.1k100% same
Edited · 0
None found.
Wrote their own version · 0
None found.
How matches are found. Word for word: the exact same text. Edited: shares passages with this file (“99% same” means 99% of its five-word phrases also appear here; 10% or more counts). Their own version: similar meaning, or, weakest, the same name. We can’t tell which project had it first. Projects are counted among the 200 most-starred candidates, and mentions are links to the repository we found, up to 50 per site, so both counts are a floor.
Where files are headingNew AGENTS.md files have more rules about keeping secrets out of the code, and fewer about code style.
Of the AGENTS.md files we read, the 31,439 first seen in the last six months, against the older ones: the kind of rule that gained most share, and the kind that lost most. About files like this in general, not this one, and an estimate, since a kind is a pattern in the words.
In this repository7 other files it gives its agents.
- CLAUDE.mdCLAUDE.md
- fix_bugSkill
- pg_dumpSkill
- postgres_syntaxSkill
- review_commentsSkill
- run_testsSkill
- validate_dbSkill
The file
We split this AGENTS.md into the rules it gives an agent
3 rules. About 0 are common, 1 is distinctive, and 2 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈1
Distinctive · estimate
This author's own choices. Worth a look.
2
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Very specific: line 6
Use the /trellis:start command when starting a new session to:
- Very specific: line 11
Use @/.trellis/ to learn:
- Distinctive: line 16
Keep this managed block so 'trellis update' can refresh the instructions.
≈ “Common” is an estimate: at least 1 in 5 of the 40,246 AGENTS.md files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
<!-- TRELLIS:START -->Trellis Instructions
These instructions are for AI assistants working in this project.
Use the /trellis:start command when starting a new session to:
- Initialize your developer identity
- Understand current project context
- Read relevant guidelines
Use @/.trellis/ to learn:
- Development workflow (
workflow.md) - Project structure guidelines (
spec/) - Developer workspace (
workspace/)
Keep this managed block so 'trellis update' can refresh the instructions.
<!-- TRELLIS:END -->Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

