DataMCP — Secure MCP Gateway for PostgreSQL
io.github.mironovisa/datamcp
11 toolsHTTPregistry active
Summary
Gives AI tools like Cursor and Claude direct access to your PostgreSQL database through MCP with a permission layer in between. You get schema introspection and SQL query execution with configurable read-only, read-write, or per-table access controls. Connection strings are encrypted at rest with AES-256-GCM, queries are validated before execution, and everything hits an audit log. Useful when you want AI to read your schema and run queries during development without granting full database access. Works over streamable HTTP, so it plugs into any MCP client without local setup. Free tier includes one connection and one MCP link.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Tools
Public tool metadata for what this MCP can expose to an agent.
11 tools
setupGet started with DataMCP. Returns instructions for connecting your first PostgreSQL database.
Get started with DataMCP. Returns instructions for connecting your first PostgreSQL database.
No parameter schema in public metadata yet.
list_connectionsList all database and API connections for the authenticated user1 params
List all database and API connections for the authenticated user
Parameters* required
typestringFilter connections by type (optional)one of
database · openapi · gitget_schemaGet the current database schema for a specific connection1 params
Get the current database schema for a specific connection
Parameters* required
connectionIdstringThe connection ID (e.g., conn_abc123)
search_tablesSearch for tables by name across all connections1 params
Search for tables by name across all connections
Parameters* required
querystringSearch query (table name)
list_api_endpointsList all API endpoints for a specific OpenAPI connection1 params
List all API endpoints for a specific OpenAPI connection
Parameters* required
connectionIdstringThe OpenAPI connection ID
search_endpointsSearch for API endpoints across all OpenAPI connections1 params
Search for API endpoints across all OpenAPI connections
Parameters* required
querystringSearch query (endpoint path or description)
get_repository_structureGet the file tree structure of a Git repository1 params
Get the file tree structure of a Git repository
Parameters* required
connectionIdstringThe Git connection ID
get_file_contentGet the content of a specific file from a Git repository2 params
Get the content of a specific file from a Git repository
Parameters* required
pathstringThe file path (e.g., src/index.ts)
connectionIdstringThe Git connection ID
search_repository_filesSearch for files in a Git repository by path or extension3 params
Search for files in a Git repository by path or extension
Parameters* required
querystringSearch query (file path pattern)
extensionstringFilter by file extension (e.g., .ts, .js)
connectionIdstringThe Git connection ID
get_commit_historyGet the commit history of a Git repository2 params
Get the commit history of a Git repository
Parameters* required
limitnumberMaximum number of commits to return (default: 10)
connectionIdstringThe Git connection ID
get_readmeGet the README content of a Git repository1 params
Get the README content of a Git repository
Parameters* required
connectionIdstringThe Git connection ID
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
