Postgres
Skill CodelyTV/agentic_programming-course/05-mcps/3-mcp_vs_cli/2-simple_cli/.agents/skills/postgres
Agentic Programming with AI: Practical Fundamentals course examples
npx -y skills add CodelyTV/agentic_programming-course --skill postgresAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
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.
SKILL.md
0.7 KB, 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.tablesdirectly instead of reading migration files. - Go straight to the query. No need to inspect Docker or init scripts beforehand.