Agent skill
postgres
Manage PostgreSQL databases via the psql CLI.
Install this agent skill to your Project
npx add-skill https://github.com/olasunkanmi-SE/codebuddy/tree/main/skills/postgres
Metadata
Additional technical details for this skill
- auth
-
{ "type": "none" } - icon
- postgres
- version
- 1.0.0
- category
- databases
- displayName
- PostgreSQL
- dependencies
-
{ "cli": "psql", "install": { "linux": { "apt": "postgresql-client" }, "darwin": { "brew": "postgresql" }, "windows": { "scoop": "postgresql" } }, "checkCommand": "psql --version", "bundledInstall": "skills/postgres/install.sh" }
SKILL.md
psql
Use psql to interact with PostgreSQL databases.
Common Commands
Connection
- Connect:
psql "postgresql://user:password@host:port/dbname"
Operations
- List databases:
\l - List tables:
\dt - Describe table:
\d <table_name> - Execute query:
SELECT * FROM table LIMIT 10; - Quit:
\q
Notes
- Requires
psqlto be installed in the environment.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
Send emails using mailsend-go CLI
aws
Manage AWS resources via the aws CLI.
telegram
Send Telegram messages, files, and interact with Telegram bots via the telegram-send CLI tool.
redis
Manage Redis databases via the redis-cli tool.
datadog
Query metrics, manage monitors, post events, and interact with Datadog via the dogshell CLI.
linear
Manage Linear issues via the linear-cli (unofficial or custom wrapper).
Didn't find tool you were looking for?