postgres
Manage PostgreSQL databases via the psql CLI. Use when querying, inspecting schema, or managing PostgreSQL databases.
Source facts
- Repository
- fworks-tech/agenthood
- Last source activity
- September 16, 2026 at 21:10
- Detected SKILL.md language
- English
- Stars
- 3
- Forks
- 0
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- postgres
- description
- Manage PostgreSQL databases via the psql CLI. Use when querying, inspecting schema, or managing PostgreSQL databases.
- license
- MIT
- metadata
- {"category":"databases","dependencies":{"cli":"psql","checkCommand":"psql --version","install":{"darwin":"[Truncated]","linux":"[Truncated]","windows":"[Truncated]"}}}
# 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.
View on GitHub