CD postgres
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. **Trigger when user asks to:** - Explore an existing PostgreSQL database to understand its objects and relationships - Design or modify PostgreSQL tables, schemas, or data models - Choose data types, constraints, indexes, or partitioning strategies - Work with pgvector embeddings, semantic search, or RAG - Set up full-text search, hybrid search, or BM25 ranking - Use PostGIS for spatial/geographic data - Set up TimescaleDB hypertables for time-series data - Migrate tables to hypertables or evaluate migration candidates - Plan or execute safe schema migrations with zero downtime **Keywords:** PostgreSQL, Postgres, SQL, schema, table design, indexes, constraints, pgvector, PostGIS, TimescaleDB, hypertable, semantic search, hybrid search, BM25, time-series, migration
Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and…
As a process D 44/100 · Unfinished process — References files that are not bundled: references/schema-exploration/guide.md, references/design-postgres-tables.md, references/design-postgis-tables.md
How to improve
- The text references files that are not there: add them or drop the references.
- Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
- A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.
Guard findings · 0
✓ No critical or high findings
Files scanned: 1. Evidence is masked. Grey chips explain why severity was lowered.
Against the Agent Skills spec
- warning
missing-refreference to a missing file: references/schema-exploration/guide.md - warning
missing-refreference to a missing file: references/design-postgres-tables.md - warning
missing-refreference to a missing file: references/design-postgis-tables.md - warning
missing-refreference to a missing file: references/pgvector-semantic-search.md - warning
missing-refreference to a missing file: references/postgres-hybrid-text-search.md - warning
missing-refreference to a missing file: references/setup-timescaledb-hypertables.md - warning
missing-refreference to a missing file: references/find-hypertable-candidates.md - warning
missing-refreference to a missing file: references/migrate-postgres-tables-to-hypertables.md - warning
missing-refreference to a missing file: references/postgres-database-migration.md
Process rating: all ten parameters 44/100
- 0Tools and files. 9 referenced file(s) missing: references/schema-exploration/guide.md, references/design-postgres-tables.md, references/design-postgis-tables.md
- 0Result and completion. Does not say what the result is
- 0Inputs and preconditions. Does not say what the process needs to start
- 0Progress reporting. Says nothing while it works
- 50Failures and branches. 0 branches, has a failure section
- 70When it triggers. States when to use, but not when not to
- 85Steps. 12 steps, 1 vague phrases
- 100Consistency. Name and required fields are in place
- 100Execution cost. Instruction body is 677 tokens
- 100Running it twice. No mutating operations
Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.
Quality signals
- +5Description has no quoted example phrases that should trigger the skill
- +4Description does not say when NOT to use the skill (false activations)
- +3Description length 944: 120–800 characters recommended
- +3Output format is not stated: the model decides each time
- +4No input/output examples
- +2Single-language instructions
- +4Structure: 8 headings
- +3Step-by-step instructions: 12 items
- +1License stated
Quality base 70; lint remarks subtract, signals add up to 100. Result: 66.