# Postgres Analyst MCP server

> Lets AI assistants explore and query PostgreSQL or SQLite databases using a secure, read-only interface with SQL validation and column masking.

- Repository: https://github.com/AkibUllah/mcp-postgres-analyst
- Page: https://hostedmcp.org/servers/akibullah/mcp-postgres-analyst
- Transport: —
- Stars: 0
- License: MIT

## Environment variables

| Name | Required | Secret | Description |
|---|---|---|---|
| `AUDIT_LOG_PATH` | no | no |  |
| `DATABASE_URL` | no | no |  |
| `POLICY_PATH` | no | no |  |

## Tools (7)

- `list_schemas`
- `describe_table`
- `sample_rows`
- `run_query`
- `explain_query`
- `find_columns`
- `run_saved_query`

## FAQ

### Is the database access read-only?

Yes, the server ensures read-only access through multiple layers, including SQL allow-lists, a read-only database session, and specific database role permissions.
