Agentic_programming-course 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.

install
source · Clone the upstream repo
git clone https://github.com/CodelyTV/agentic_programming-course
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/CodelyTV/agentic_programming-course "$T" && mkdir -p ~/.claude/skills && cp -r "$T/05-mcps/3-mcp_vs_cli/4-multiple_cli/.agents/skills/postgres" ~/.claude/skills/codelytv-agentic-programming-course-postgres-b30612 && rm -rf "$T"
manifest: 05-mcps/3-mcp_vs_cli/4-multiple_cli/.agents/skills/postgres/SKILL.md
source content

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.