postgres

Solid

Query the connected PostgreSQL database with psql. Use when the user asks about their database — tables, rows, schema, or to run SQL against Postgres.

API & Backend 22 stars 3 forks Updated today MIT

Install

View on GitHub

Quality Score: 79/100

Stars 20%
45
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
39
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# PostgreSQL (connected) The connection string is in `$POSTGRES_URL` — pass it to `psql` as the first argument. `psql` is preinstalled once the sandbox has been rebuilt for this capability (Environment card). - List tables: `psql "$POSTGRES_URL" -c "\dt"` - Describe a table: `psql "$POSTGRES_URL" -c "\d <table>"` - Run a query: `psql "$POSTGRES_URL" -c "SELECT * FROM <table> LIMIT 20"` - Scriptable output (no headers/formatting, one value): `psql "$POSTGRES_URL" -tAc "SELECT count(*) FROM <table>"` - List databases / schemas: `psql "$POSTGRES_URL" -c "\l"` / `psql "$POSTGRES_URL" -c "\dn"` Notes: this is a read-write connection — the connected role's grants bound what you can do. Wrap risky writes in `BEGIN; … COMMIT;` and prefer a `WHERE` on every `UPDATE`/`DELETE`.

Details

Author
intentic
Repository
intentic/intentic
Created
2 weeks ago
Last Updated
today
Language
TypeScript
License
MIT

Integrates with

Similar Skills

Semantically similar based on skill content — not just same category