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

  1. In Claude, open Settings → Connectors → Add custom connector.
  2. Enter this server's address: https://mcpdb.optimivas.com/mcp-common-db
  3. Sign in when prompted. Your organization must have an active subscription, and your database connections must already be set up by your administrator.
  4. Start a chat and ask about your data. Claude picks the right tool automatically.

Things you can ask:

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

ToolWhat it doesType
list_connectionsList the names of the database connections available to you.Read-only
list_tablesList the tables in a connection, optionally filtered by schema.Read-only
get_table_schemaDescribe a table's columns (names, types, nullability).Read-only
summarize_tableProfile a table in one query: row count, plus nulls, distinct values and min/max/avg per column.Read-only
run_queryRun a SELECT query (up to 1,000 rows, with a configurable timeout). Anything that writes is rejected.Read-only
execute_statementRun INSERT, UPDATE, DELETE or DDL and commit. Refused on connections marked read-only.Modifies data
migrate_dataCopy 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.