# Data Studio Agent MCP server

> Enables AI coding agents to securely access and query SQL and NoSQL databases using plain language via dockit and sqlkit desktop apps.

- Repository: https://github.com/geek-fun/data-studio-agent
- Page: https://hostedmcp.org/servers/geek-fun/data-studio-agent
- Transport: stdio
- Stars: 3
- License: Apache-2.0
- Latest version: 0.1.12

## Install

### Claude Code

```sh
claude mcp add data-studio-agent -- npx -y @geek-fun/data-studio-mcp
```

### Cursor (`~/.cursor/mcp.json`)

```json
{
  "mcpServers": {
    "data-studio-agent": {
      "command": "npx",
      "args": [
        "-y",
        "@geek-fun/data-studio-mcp"
      ]
    }
  }
}
```

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "data-studio-agent": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@geek-fun/data-studio-mcp"
      ]
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"data-studio-agent","type":"stdio","command":"npx","args":["-y","@geek-fun/data-studio-mcp"]}'
```

### Claude Desktop (`claude_desktop_config.json`)

```json
{
  "mcpServers": {
    "data-studio-agent": {
      "command": "npx",
      "args": [
        "-y",
        "@geek-fun/data-studio-mcp"
      ]
    }
  }
}
```

### Codex

```sh
codex mcp add data-studio-agent -- npx -y @geek-fun/data-studio-mcp
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.data-studio-agent]
command = "npx"
args = ["-y", "@geek-fun/data-studio-mcp"]
```

### Gemini CLI

```sh
gemini mcp add -s user data-studio-agent npx -- -y @geek-fun/data-studio-mcp
```

### Gemini settings.json (`~/.gemini/settings.json`)

```json
{
  "mcpServers": {
    "data-studio-agent": {
      "command": "npx",
      "args": [
        "-y",
        "@geek-fun/data-studio-mcp"
      ]
    }
  }
}
```

## Tools (2)

- `data_studio__list_connections`: List all database connections from both dockit and sqlkit. Each entry has { backend, id, name, type } — use id as connection_id when calling database tools. If no connections appear, call data_studio__get_status. (read-only)
- `data_studio__get_status`: Get Data Studio MCP server status and backend availability. Call this first if tools seem missing or a backend tool fails. (read-only)

## FAQ

### Which databases are supported?

It supports over 70 SQL databases including PostgreSQL, MySQL, SQL Server, and Snowflake, as well as NoSQL databases like Elasticsearch, MongoDB, and DynamoDB.

### Is my database credential safe?

Yes, credentials never leave your local apps. The LLM only receives an opaque connection ID, and real credentials are resolved inside dockit or sqlkit.

### Can the AI delete my data?

Destructive operations like DELETE or DROP require Full Access permission and will trigger an explicit user confirmation prompt in your AI client.

### What operating systems are supported?

The server works on macOS, Windows, and Linux.
