@apono-io/mcp-postgres
v0.1.1
Published
Apono MCP server for PostgreSQL databases with JIT credential support
Downloads
544
Readme
@apono-io/mcp-postgres
Apono MCP server for PostgreSQL databases with JIT credential support.
Tools
| Tool | Description |
|------|------------|
| query | Execute a read-only SQL SELECT query and return results |
| execute | Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE) |
| list_schemas | List all schemas in the database |
| list_tables | List all tables in a schema |
| describe_table | Get column names, types, constraints, and indexes for a table |
| list_extensions | List installed PostgreSQL extensions |
| get_table_indexes | List indexes on a specific table |
| explain_query | Get the execution plan for a SQL query |
All tools accept a database parameter to specify which database to operate on.
Environment Variables
| Variable | Description |
|----------|------------|
| POSTGRES_HOST | PostgreSQL server hostname |
| POSTGRES_PORT | PostgreSQL server port (default: 5432) |
| POSTGRES_USER | Database username |
| POSTGRES_PASSWORD | Database password |
