agentsclimarketplace
Sign in

Postgres

Skill CodelyTV/agentic_programming-course/05-mcps/3-mcp_vs_cli/4-multiple_cli/.agents/skills/postgres

Execute queries on the Postgres database. Use this skill DIRECTLY whenever the user asks anything about database contents, counts, or data — do NOT read compose.yml or SQL migration files first.From its SKILL.md

Install
npx -y skills add CodelyTV/agentic_programming-course --skill postgres

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

2 things to look at

  • reads credentialsReads from 1 credential source: `PGPASSWORD`.
  • runs commandsInstructs the agent to run 1 command, including `echo "<SQL_QUERY>" | PGPASSWORD=c0d3ly7v psql -h localhost -p 5432 -U supabase_admin -d postgres -tA`.

SKILL.md

0.7 KB, 108 tokens by cl100k_base, as published. Nobody here has run it

Execute SQL queries against the local Postgres database using psql.

Pipe the query via stdin:

echo "<SQL_QUERY>" | PGPASSWORD=c0d3ly7v psql -h localhost -p 5432 -U supabase_admin -d postgres -tA

Tips

  • If you need to discover schemas or tables, query information_schema.tables directly instead of reading migration files.
  • Go straight to the query. No need to inspect Docker or init scripts beforehand.

What ships with it

Read from the repository

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

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.