# dkbearsong/postgres-mcp

Source: https://glimind.com/server/glama%2Fdkbearsong%2Fpostgres-mcp
Registry id: `glama/dkbearsong/postgres-mcp`
Status: unknown

## Tools (7)

- `backup_database`: Runs a full database schema and data backup immediately.
- `delete_records`: Deletes rows from a table. Backs up matching records to a timestamped CSV before performing the delete. Rotates backups based on retention settings, and runs a 
- `execute_read_query`: Executes a read-only query. Limits results to ROW_LIMIT (default 500) and returns results in a structured JSON format.
- `execute_write_query`: Executes write queries (INSERT, UPDATE, DELETE). Requires explicit confirmation.
- `export_to_csv`: Executes a SELECT query and exports the structured results directly to a CSV file in the backups directory.
- `get_schema_info`: Lists all database tables and schema-wide foreign key relationships.
- `get_table_details`: Retrieves column schemas, CHECK constraints, indexes, and descriptions for a specific table.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.
