Database MCP Server
Let Claude explore, query and manage your databases in plain language — without sharing credentials in the chat.
1. What is this?
This is a Model Context Protocol (MCP) server. Once you add it to Claude as a connector, Claude can look at your database structure, run SQL, and copy data between tables on your behalf.
It works with PostgreSQL, MySQL, Oracle, SQL Server and SQLite. Databases are set up as named connections; Claude only ever sees the name, never the host, user or password.
Read-only and write operations are separate tools, so Claude's approval prompts clearly show when something will change data.
2. How to use it
- In Claude, open Settings → Connectors → Add custom connector.
- Enter this server's address:
https://mcpdb.optimivas.com/mcp-common-db - Sign in when prompted. Your organization must have an active subscription, and your database connections must already be set up by your administrator.
- Start a chat and ask about your data. Claude picks the right tool automatically.
Things you can ask:
- “Which database connections do I have, and what tables are in
sales?” - “Describe the
orderstable and tell me which columns are mostly empty.” - “Show total revenue by month for the last year.”
- “Copy last quarter's rows from
ordersintoorders_archive— do a dry run first.”
Signing in
You sign in from Claude: click Connect on the connector and a secure sign-in page opens. Sign up or log in with Google, Microsoft, or your email and password.
Signing in proves who you are. Your administrator must also link your account to your organization before you can see any database connections. If Claude says your organization is not registered, send your sign-in email address to your administrator, then click Connect again.
Just verified your email or reset your password? Go back to Claude and click Connect to finish.
3. Available tools
| Tool | What it does | Type |
|---|---|---|
list_connections | List the names of the database connections available to you. | Read-only |
list_tables | List the tables in a connection, optionally filtered by schema. | Read-only |
get_table_schema | Describe a table's columns (names, types, nullability). | Read-only |
summarize_table | Profile a table in one query: row count, plus nulls, distinct values and min/max/avg per column. | Read-only |
run_query | Run a SELECT query (up to 1,000 rows, with a configurable timeout). Anything that writes is rejected. | Read-only |
execute_statement | Run INSERT, UPDATE, DELETE or DDL and commit. Refused on connections marked read-only. | Modifies data |
migrate_data | Copy rows from one table to another — same database, across databases, or across servers — with optional filter, column mapping, batching and a dry-run mode. | Modifies data |
Self-hosted installs can also enable report and export tools (Excel and Word reports, JSON and XML export). They are turned off on this hosted service.