1. Conduid
  2. Data
  3. Datagrip Database MCP
MCP server · Data

Datagrip Database MCP

DataGrip plugin that extends the built-in MCP server with database query and schema tools for AI assistants

34Low

Scored 6 months ago · breakdown

About Datagrip Database MCP

Datagrip Database MCP is an MCP server in the Data category: dataGrip plugin that extends the built-in MCP server with database query and schema tools for AI assistants.

Install

From source
git clone https://github.com/siddiqui-zeeshan/datagrip-database-mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Tools (6)

explain_query`datasource`, `sql`

Parameters not published.

get_schema`datasource`, `schema?`

Parameters not published.

get_table_info`datasource`, `table`, `schema?`

Parameters not published.

list_datasources_(none)_

Parameters not published.

run_query`datasource`, `sql`, `rowLimit?`, `timeout?`

Parameters not published.

search_schema`datasource`, `pattern`

Parameters not published.

Ask AI

✦

Ask AI about Datagrip Database MCP

Powered by Claude · Grounded in docs

I know everything about Datagrip Database MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

  • ✓README presentThe repository ships documentation.

5 checks have not been run yet.

README

Database MCP Tools

A DataGrip plugin that extends its built-in MCP server with 6 database tools. AI assistants like Claude Code can query databases through DataGrip's existing connections -- SSH tunnels, SSL, and auth included -- with zero extra config.

Requirements

  • DataGrip 2025.3+
  • JDK 17+

Building

./gradlew buildPlugin

The plugin zip is written to build/distributions/.

Installation

  1. In DataGrip, go to Settings > Plugins.
  2. Click the gear icon and select Install Plugin from Disk....
  3. Select the zip from build/distributions/.
  4. Restart DataGrip.

Setup

  1. Enable the MCP server in DataGrip: Settings > Tools > MCP Server (requires DataGrip 2025.3+).
  2. Datasources auto-connect on demand -- no manual connect step needed (passwords must be saved in DataGrip).
  3. Configure Claude Code (or another MCP client) to use DataGrip's MCP server.

Option A: Database tools only (recommended)

Use the filter proxy to expose only the 6 database tools. This strips DataGrip's built-in IDE tools from the MCP response, keeping your AI assistant's context clean.

Download the proxy script:

curl -o mcp-filter-proxy.py https://raw.githubusercontent.com/siddiqui-zeeshan/datagrip-database-mcp/main/mcp-filter-proxy.py
{
  "mcpServers": {
    "datagrip-db": {
      "command": "python3",
      "args": [
        "/path/to/mcp-filter-proxy.py",
        "/path/to/java",
        "-classpath",
        "/path/to/mcpserver-classpath",
        "com.intellij.mcpserver.stdio.McpStdioRunnerKt"
      ],
      "env": {
        "IJ_MCP_SERVER_PORT": "<port>"
      }
    }
  }
}

See Classpath and port below for how to find the correct values.

Option B: All tools (database + built-in IDE tools)

Connect directly to DataGrip's MCP server without filtering. This exposes all built-in IDE tools alongside the database tools.

{
  "mcpServers": {
    "datagrip": {
      "command": "/path/to/java",
      "args": [
        "-classpath",
        "/path/to/mcpserver-classpath",
        "com.intellij.mcpserver.stdio.McpStdioRunnerKt"
      ],
      "env": {
        "IJ_MCP_SERVER_PORT": "<port>"
      }
    }
  }
}

Classpath and port

The MCP server runs via DataGrip's bundled JRE, not the DataGrip CLI. You need two things:

  1. Java binary: <DataGrip install>/Contents/jbr/Contents/Home/bin/java (macOS) or the equivalent on your OS.
  2. Classpath: the JARs under <DataGrip install>/Contents/plugins/mcpserver/lib/ and <DataGrip install>/Contents/lib/. See the global MCP setup section for details.
  3. Port: set IJ_MCP_SERVER_PORT to the port shown in DataGrip under Settings > Tools > MCP Server.
OS DataGrip install path
macOS (Toolbox) ~/Library/Application Support/JetBrains/Toolbox/apps/datagrip/
macOS (standalone) /Applications/DataGrip.app/
Linux (Toolbox) ~/.local/share/JetBrains/Toolbox/apps/datagrip/
Windows (Toolbox) %LOCALAPPDATA%\JetBrains\Toolbox\apps\datagrip\

The 6 database tools will appear automatically once the plugin is installed and the MCP server is enabled.

Tools

Tool Parameters Returns
list_datasources (none) Name, driver, connection status, and write-enabled flag for each datasource
get_schema datasource, schema? Tables with columns, types, primary keys, and nullability
run_query datasource, sql, rowLimit?, timeout? Columns, rows, row count, and whether results were truncated
explain_query datasource, sql Execution plan (auto-prefixes the correct EXPLAIN syntax for the DB driver)
get_table_info datasource, table, schema? Columns, types, primary keys, foreign keys, and indexes for a single table
search_schema datasource, pattern Tables and columns matching the pattern, with their types

Datasources auto-connect on demand. Passwords must be saved in DataGrip for unattended connections.

Safety

Read-only by default. Only SELECT, EXPLAIN, SHOW, DESCRIBE, and WITH statements are allowed unless writes are explicitly enabled.

  • Per-datasource write toggle: Settings > Tools > Database MCP Tools
  • Query timeout: 30 seconds (default), configurable per datasource
  • Row limit: 1000 rows (default), configurable per datasource and overridable per query via the rowLimit parameter
  • Response size cap: ~100KB -- results are truncated if they exceed this

Development

Launch a DataGrip sandbox with the plugin loaded:

./gradlew runIde

Run tests:

./gradlew test

README copy captured when this server was indexed; it may lag the repository. The original is authoritative.

Questions

About Datagrip Database MCP

How do I install Datagrip Database MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Datagrip Database MCP safe to use with an AI agent?

Its trust score is 34 out of 100 (low). It passes 1 of the 1 static security checks run so far. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Datagrip Database MCP still maintained?

Conduid hasn't recorded a commit date for this repository yet. Check the repository directly for recent activity.