Ditto MCP Server — Secure DQL for Ditto

📚 Table of Contents

• Ditto MCP Server — Secure DQL for Ditto

  • 📚 Table of Contents

  • Overview

    • Features

  • Requirements

  • Quick Start (Local)

  • Install in Clients

    • Cursor

    • Claude Code CLI

    • VS Code Copilot Chat (Insiders)

    • Windsurf

    • Zed

    • Roo Code / Cline

    • JetBrains AI Assistant

    • LM Studio

    • Warp

    • Amazon Q Developer CLI

    • Gemini CLI

  • Tools & Resources

    • Example: SELECT with named args

  • Configuration

    • MCP Client One‑click Patterns

  • Security Notes

  • Development

    • Test with MCP Inspector

    • Alternative Runtimes

    • Docker

  • Troubleshooting

  • Versioning & Changelog

  • License

Overview

An open‑source Model Context Protocol server that executes Ditto DQL over HTTPS with capability gating and safety checks. Designed for Cursor, Claude Code, VS Code Copilot Chat (MCP), Windsurf, Zed, and more.

Features

• Ping health tool, execute_dql tool, and ditto://config resource

• Statement guardrails: single statement, operation allow‑list, optional query pattern allow‑list

• Config via env, CLI, or client config

• Native ESM, strict TypeScript, zero runtime deps beyond MCP SDK

Requirements

• Node.js >= 18.17

• A Ditto app base URL, e.g. https://MY_APP.cloud.ditto.live

• A Ditto API key with access to that app

Quick Start (Local)

Defaults to stdio transport. Provide env vars (recommended):

Install in Clients

Below are minimal JSON snippets. See each client’s docs for full syntax and options.

Cursor

Add to ~/.cursor/mcp.json or project .cursor/mcp.json:

Claude Code CLI

VS Code Copilot Chat (Insiders)

Windsurf

Add to Windsurf MCP config (see their docs for exact path):

Zed

Add to ~/.config/zed/settings.json:

Roo Code / Cline

Add in settings under MCP servers or marketplace manual JSON:

JetBrains AI Assistant

Settings → Tools → AI Assistant → MCP → Add → As JSON:

LM Studio

Program → Install → Edit mcp.json:

Warp

Settings → AI → Manage MCP servers:

Amazon Q Developer CLI

~/.aws/q/developer/cli/config.json:

Gemini CLI

~/.gemini/settings.json:

Tools & Resources

• ping – returns pong for connectivity check

• execute_dql – run a parameterized DQL against Ditto

  • statement (string, required) – single statement, no trailing ;

  • args (object, optional) – named parameters

  • transactionId (number, optional) – X‑DITTO‑TXN‑ID

  • apiKey (string, optional) – override key; prefer env

  • baseUrl (string, optional) – override base URL

  • timeoutMs (number, optional, <= 60000)

• Resource: ditto://config – redacted runtime config

Example: SELECT with named args

Returns a JSON envelope with items, queryType, warnings, and optional error.

Configuration

You can configure via env, CLI, or client configs. Env is preferred for secrets.

Environment variables:

• DITTO_BASE_URL – e.g. https://MY_APP.cloud.ditto.live

• DITTO_API_KEY – Ditto API key

• MCP_DITTO_ALLOWED – READ, ALL, or a comma list like SELECT,INSERT

• MCP_DITTO_QUERY_ALLOW_PATTERNS – comma/semicolon‑separated regex allow‑list

• DITTO_TIMEOUT_MS – default per‑call timeout (ms)

• DITTO_API_KEY_ENV – env var name to read API key from (default DITTO_API_KEY)

• MCP_SERVER_NAME – server display name

• MCP_SERVER_VERSION – overrides the reported server version (default: package.json version; fallback: 0.0.0-dev)

• LOG_LEVEL – controls logging verbosity: debug|info|warn|error|silent (default: info)

Configuration precedence: CLI flags > environment variables. Reported version precedence: MCP_SERVER_VERSION > package.json > 0.0.0-dev.

CLI flags (subset):

Transport argument defaults to stdio. This package currently exposes stdio only.

MCP Client One‑click Patterns

• Cursor deeplink button above for instant install into ~/.cursor/mcp.json.

Security Notes

• Prefer environment variables for secrets; avoid CLI args containing secrets

• Allowed operation gating and optional regex allow‑list help constrain queries

• Logs redact tokens and obvious secret patterns

Development

Linting is TypeScript‑strict by design. The prepack script builds automatically before npm publish.

Test with MCP Inspector

Alternative Runtimes

Windows PowerShell example:

Docker

Build the image:

Run with env vars:

You can also configure Docker as a local MCP command in clients that support running a container for stdio transport. Example:

Troubleshooting

• If tools don’t appear, refresh/toggle the server in your client

• Ensure DITTO_BASE_URL and DITTO_API_KEY are set

• In Windows, provide full node and dist/index.js paths if needed

If your client has trouble auto-installing via npx, try bunx -y ditto-mcp-server.

Versioning & Changelog

See CHANGELOG.md.

License

MIT © EVT Engineering and contributors

This project is not affiliated with Ditto. “Ditto” is a respective trademark of its owner.