CLAUDE MCP GUIDE

How to connect your data to Claude.

Data Connector gives Claude a hosted, read-only MCP path to live PostgreSQL or MySQL, and tables imported from CSV, Parquet, or SQLite.

  1. Sign in or sign up with Loam, then choose or create a workspace.
  2. Choose Add data. Connect PostgreSQL or MySQL, import Search Console or Stripe reports, or upload a CSV, Parquet or SQLite file.
  3. Add Data Connector in Claude or an OAuth-compatible MCP client, approve workspace access, then ask about your data.

File imports upload a copy to your workspace; processing is remote. Your original file stays unchanged and later changes are not synced.

1. Choose, connect, or import your data

Sign in at dataconnector.ai. Connect a public PostgreSQL or MySQL TLS endpoint with a dedicated read-only account, or upload a CSV, Parquet, or SQLite file.

2. Add the connector in Claude

In Claude, open Customize, then Connectors. Choose Add custom connector and enter:

https://dataconnector.ai/api/mcp

Select Connect, complete OAuth, and choose the Data Connector workspace that contains your source. Claude Team and Enterprise organizations may require an Owner to add the connector first.

3. Or add it to Claude Code

claude mcp add --transport http data-connector https://dataconnector.ai/api/mcp
claude mcp list

Open Claude Code, run /mcp, select Data Connector, and complete OAuth. You never paste your database password into Claude.

See the official Claude custom connector guide and Claude Code MCP documentation for current client requirements.

4. Start with discovery

Try: List the data sources and tables I can access, then describe the reporting data. Follow with a focused analytical question. Data Connector bounds each query and returns structured results.

Frequently asked questions

How does Claude connect to my database?

Claude calls Data Connector through MCP. Data Connector keeps source credentials on the server and checks your workspace access.

Which data can I connect to Claude?

Data Connector provides read-only access to live PostgreSQL or MySQL, plus tables imported from CSV, Parquet, and SQLite files.

Can Claude write to my database?

No. The current Data Connector tools are read-only and each query runs with strict limits.

Connect my data General MCP setup
SQLite Editorby Loamstack

Explore Data Connector