Postgres

Skill fworks-tech/agenthood/skills/postgres

Manage PostgreSQL databases via the psql CLI. Use when querying, inspecting schema, or managing PostgreSQL databases.From its SKILL.md

Install

npx -y skills add fworks-tech/agenthood --skill postgres

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

3 things to look at

reads credentialsReads from 1 credential source: `DATABASE_URL`.
2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
runs commandsInstructs the agent to run 8 commands, including `psql "postgresql://user:password@host:port/dbname"` and 7 more.

SKILL.md

0.9 KB, 161 tokens by cl100k_base, as published. Nobody here has run it

psql

Use psql to interact with PostgreSQL databases.

Common Commands

Connection

Connect: psql "postgresql://user:password@host:port/dbname"
Connect with env var: psql "${DATABASE_URL}"

Inspection

List databases: \l
List tables: \dt
Describe table: \d <table_name>
List schemas: \dn

Queries

Execute query: psql -c "SELECT * FROM table LIMIT 10" "${DATABASE_URL}"
Execute from file: psql -f migration.sql "${DATABASE_URL}"
Quit: \q

Notes

Requires psql installed. Set DATABASE_URL environment variable for connection string.

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Gives 0 of the 12 instructions most databases sql skills give in 161 tokens

Counted across 609 of the 712 authors here whose files we hold, read 2026-09-06

Index all foreign key columnsin 26 of 609
Use cursor pagination instead of offsetin 25 of 609, across 20 files
Use timestamptz for timestampsin 21 of 609
Specify columns instead of using select starin 20 of 609, across 10 files
Use parameterized queries for all database interactionsin 20 of 609, across 19 files
Use Enum for categorical datain 17 of 609, across 7 files
Order by frequently filtered columnsin 17 of 609, across 7 files
Batch data insertsin 17 of 609, across 7 files
Use expand-contract pattern for schema changesin 17 of 609
Use materialized views for real-time aggregationsin 16 of 609, across 6 files
Partition tables by timein 16 of 609, across 6 files
Use smallest appropriate data typesin 16 of 609, across 6 files

Said here and by no other author read

Use psql -c to execute queries

Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.