Installs into .claude/skills of the current project.
Are you the author of Connect Postgres?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/black141312-connect-postgres)
---
name: connect-postgres
description: Connect ada to a Postgres database (read-only SQL) via the Postgres MCP server.
category: connectors
---
# Connect Postgres
Use when the user wants ada to inspect a schema or run read-only analytics queries against Postgres.
1. Add the connector: `ada mcp add postgres`.
2. Edit the connection string in `.ada/mcp.json` (the last arg) to point at your database — prefer a **read-only** role and a non-prod replica.
3. Keep credentials out of the file: use a role whose password is supplied via the environment or a `.pgpass`, not inline.
4. Trust the project and start `ada`; the tools appear as `postgres__*` (schema introspection + query).
5. Start by listing tables / describing the schema before writing any query.
## Rules
- Connect with a read-only user — never hand ada write/DDL credentials to "just query".
- Point at a replica or dev DB, not production, when possible.
- Review any generated SQL before running it on a large table; add `LIMIT` while exploring.
