Drizzle Cube

What it does

Drizzle Cube is a type-safe semantic layer built on Drizzle ORM. Define cubes (measures, dimensions, joins) on your existing schema, then query them from React dashboards, AI agents via MCP, or your own API. It brings Cube.js-style analytics to the Drizzle ecosystem with full TypeScript inference and SQL injection protection.

Key features

• Built-in MCP server — Expose your semantic layer at /mcp so Claude, ChatGPT, and other AI clients can query your data with natural language
• Interactive dashboards — Drag-and-drop Analysis Builder, funnel analysis, flow analysis, retention cohorts, and grid-layout dashboards with React components
• Multi-tenant security — Security context filters every query automatically at the semantic layer — no manual WHERE clause management
• Multiple DB support — PostgreSQL, MySQL, SQLite, DuckDB, Databend, Snowflake
• Framework adapters — Hono, Express, Fastify, Next.js out of the box
• Claude Code plugin — Query your data with natural language directly inside Claude Code

Installation

Claude Desktop — Add to claude_desktop_config.json:

{
  "mcpServers": {
    "analytics": {
      "command": "npx",
      "args": ["-y", "@anthropic/mcp-remote", "https://your-app.com/mcp"]
    }
  }
}

Claude.ai — Settings → Connectors → Add your /mcp URL

ChatGPT — Settings → Connectors → Developer Mode → Add your MCP URL

Supported hosts

Claude Desktop, Claude.ai, and ChatGPT confirmed in README.