mcp_psql_manager
Manage PostgreSQL databases through encrypted credential profiles. Execute queries, explore schemas, and manipulate data with tools like quick_query, show_tables, and insert_data.
Instructions
PostgreSQL toolchain. Flow: setup_profile → action. setup_profile accepts credentials or connection_url plus optional TLS (ssl_mode, ssl_ca, ssl_cert, ssl_key, ssl_passphrase, ssl_servername, ssl_reject_unauthorized); secrets stored encrypted. Subsequent calls reuse profile_name: quick_query (adds LIMIT 100 if absent; supports params array for $ placeholders), show_tables, describe_table, sample_data, database_info, insert_data, update_data, delete_data, list_profiles.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| profile_name | No | Profile name (defaults to 'default') | |
| connection_url | No | postgres://user:pass@host:port/db url | |
| host | No | ||
| port | No | ||
| username | No | ||
| password | No | ||
| database | No | ||
| ssl | No | ||
| ssl_mode | No | disable | require | verify-ca | verify-full | |
| ssl_ca | No | PEM encoded certificate authority chain | |
| ssl_cert | No | PEM encoded client certificate | |
| ssl_key | No | PEM encoded client private key | |
| ssl_passphrase | No | Optional passphrase for the private key | |
| ssl_servername | No | Override servername for TLS verification | |
| ssl_reject_unauthorized | No | Set to false to trust self-signed certificates | |
| sql | No | ||
| params | No | ||
| table_name | No | ||
| data | No | ||
| where | No | ||
| limit | No |