PostgreSQL MCP Server
Enables AI assistants to safely interact with PostgreSQL databases, perform queries, inspect schemas, and analyze query performance
Detailed security scan evidence is not public for this MCP yet. Public identity, registry metadata, and independently observed protocol inventory remain available.
Install and connect
Installation and connection instructions are shown only when supported by retained package, repository, or endpoint evidence.
No verified installation or connection method is available in the retained evidence yet.
Identity
| Canonical slug | postgresql-mcp-server-26bfac7e | Deployment | Local Only |
|---|---|---|---|
| Canonical package | — | Repository | longgoll/mcp-postgreSql-server |
| First published | — | Latest release | — |
| Last security verification | — | Classification confidence | 90% |
| Publication | Draft | Official distribution | Not verified |
Distributions
| Channel | Identifier | Current version | Versions | Source |
|---|---|---|---|---|
| source_git | longgoll/mcp-postgresql-server | df3aa2f9a1896ce5e43dca9dc0f5d9566f7f8eff | 1 | Repository |
Current release
| Package | Version | Published / observed | Inventory | Security scan |
|---|---|---|---|---|
| source_gitlonggoll/mcp-postgresql-server | df3aa2f9a1896ce5e43dca9dc0f5d9566f7f8effCurrent | Aug 25, 2026 | 8 toolsPartial · 0 resources · 0 prompts | Evidence restricted |
Continuously monitor this MCP for security risk
Independently scan the exact version your agents use, receive alerts when its risk changes, and investigate every finding with retained version evidence.
- Independent exact-version security scans
- Continuous release and vulnerability monitoring
- Risk-change alerts with capability context
- Historical evidence and API exports
Current version evidence
No public current-version evidence is available yet.
Current protocol inventory
Tools 8
| Tool | Category | Annotations | Risk |
|---|---|---|---|
describe_tableGet schema information for a tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — | |
explain_queryGet the execution plan for a query (EXPLAIN)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — | |
list_constraintsList constraints (PK, FK, Unique, Check) for a specific tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — | |
list_indexesList indexes for a specific tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name"
]
} | — | — | |
list_tablesList all tables and views in the database (includes schema information)Input schema{
"type": "object",
"properties": {
"database": {
"type": "string",
"description": "Optional database name to query"
}
}
} | — | — | |
run_modification_queryExecute a modification SQL query (INSERT, UPDATE, DELETE, etc.)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — | |
run_read_only_queryExecute a read-only SQL query (SELECT)Input schema{
"type": "object",
"properties": {
"sql_query": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"sql_query"
]
} | — | — | |
search_in_tableSearch for a text string in all text columns of a tableInput schema{
"type": "object",
"properties": {
"table_name": {
"type": "string"
},
"search_term": {
"type": "string"
},
"database": {
"type": "string",
"description": "Optional database name to query"
}
},
"required": [
"table_name",
"search_term"
]
} | — | — |
Resources 0
- None observed.
Resource templates 0
- None observed.
Prompts 0
- None observed.
Remote endpoints
| Endpoint | Transport | Authentication | Health | Observed |
|---|---|---|---|---|
| No verified remote endpoint is linked. | ||||
PostgreSQL MCP Server questions
How do I install PostgreSQL MCP Server?
No verified package installation command is available in the retained catalog evidence.
What tools does PostgreSQL MCP Server provide?
PostgreSQL MCP Server exposed 8 tools during independent protocol observation, including describe_table, explain_query, list_constraints, list_indexes, list_tables, run_modification_query, run_read_only_query, search_in_table.
Is PostgreSQL MCP Server secure?
The selected current version does not yet have completed public verification. Unknown does not mean clean or vulnerable.
Explore related MCP server guides
Curated product and capability guides containing this catalog record.