Give Claude governed access to PostgreSQL.
Data Connector is a hosted PostgreSQL MCP server operated by Loam. It lets Claude inspect allowed schemas and query live data without copying your database into a separate sync service.
Use a dedicated read-only role
GRANT CONNECT ON DATABASE analytics TO claude_reader;
GRANT USAGE ON SCHEMA reporting TO claude_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA reporting TO claude_reader;Use a public TLS endpoint and allow only the schemas Claude needs. Loam validates the destination, stores credentials in the selected region, and executes queries in read-only transactions with time and row limits.
Connect it to Claude
After connecting PostgreSQL, add https://dataconnector.ai/api/mcp as a custom connector in Claude. OAuth binds the connector to your Loam account and selected workspace.
What this is not
Data Connector is not an ETL pipeline, replication service, or unrestricted SQL console. It currently supports PostgreSQL for live external database connections. MySQL and other live engines are not available yet.
Frequently asked questions
Does Data Connector copy my PostgreSQL database?
No. It queries the permitted live source when Claude calls a tool and does not run a sync or ETL pipeline.
Should I use my application database user?
No. Create a dedicated read-only role and grant only the schemas and tables Claude needs.
Can Data Connector connect to a private PostgreSQL hostname?
Not today. The endpoint must have a public hostname and valid TLS. Private networking needs a future tunnel or agent.