v1.0.0

Postgres Introspection Skill v1.0.0

First release of the postgres-introspection skill, which teaches an AI coding agent to build a database introspection capability inside the repository it works in.

Highlights

• A read-only introspection tool the agent recreates in the target repository, fitted to its stack, that keeps working without the skill.
• A runnable PostgreSQL reference implementation covering the database, the cluster, a connection pooler, and a REST layer.
• The method and its invariants, the classification path, and the minimal-greppable rendering discipline.
• A commenting discipline that captures the architect's intent as compact database comments, with the database as the single source of truth and documentation deriving from it.
• Guidance for reading the state and using the reports with judgment, including the alignment loop and conflict handling.
• Data-safety rules that protect existing data and database operability and require informed consent for anything consequential.

Why it matters

The real state of a database lives in the database, and the reasons behind its shape usually live nowhere durable. This skill gives a repository a tool to export the current state into shareable, credential-free, version-controlled files, and a discipline to keep the intent next to the data. Together they let teams and different AI agents reason about the database safely and see how it evolves over time.

Notes

Release tag: v1.0.0.