1.0.6npm · postgres-mysql-mcp-server · current release
Observed 2026-08-21T21:24:21.112Z using mcpSecurity-inventory. Status: succeeded. Negotiated protocol: 2024-11-05.
{
"tools": {}
}| Tool | Category | Annotations | Risk |
|---|---|---|---|
connect_databaseConnect to a PostgreSQL or MySQL database. Parameters can be provided directly or loaded from environment variables. If no parameters are provided, will use environment variables (DB_TYPE, DB_HOST, DB_PORT, DB_DATABASE, DB_USER, DB_PASSWORD, DB_SSL). For PostgreSQL: POSTGRES_HOST, POSTGRES_PORT, etc. For MySQL: MYSQL_HOST, MYSQL_PORT, etc.Input schema{
"type": "object",
"properties": {
"type": {
"type": "string",
"enum": [
"postgresql",
"mysql"
],
"description": "Database type (optional if using env vars)"
},
"host": {
"type": "string",
"description": "Database host (optional if using env vars)"
},
"port": {
"type": "number",
"description": "Database port (optional if using env vars)"
},
"database": {
"type": "string",
"description": "Database name (optional if using env vars)"
},
"user": {
"type": "string",
"description": "Database user (optional if using env vars)"
},
"password": {
"type": "string",
"description": "Database password (optional if using env vars)"
},
"ssl": {
"type": "boolean",
"description": "Use SSL connection (optional)",
"default": false
}
},
"required": []
} | — | — · — | — |
describe_tableGet schema information for a specific tableInput schema{
"type": "object",
"properties": {
"tableName": {
"type": "string",
"description": "Name of the table to describe"
}
},
"required": [
"tableName"
]
} | — | — · — | — |
disconnect_databaseDisconnect from the current databaseInput schema{
"type": "object",
"properties": {}
} | — | — · — | — |
execute_queryExecute a SQL query on the connected database. Returns query results.Input schema{
"type": "object",
"properties": {
"query": {
"type": "string",
"description": "SQL query to execute"
},
"params": {
"type": "array",
"description": "Query parameters (for parameterized queries)",
"items": {
"type": [
"string",
"number",
"boolean",
"null"
]
}
}
},
"required": [
"query"
]
} | — | — · — | — |
list_tablesList all tables in the connected databaseInput schema{
"type": "object",
"properties": {}
} | — | — · — | — |