Skip to content
MCP server

model2data studio

Generate realistic connected test data, dbt projects and dashboards from a schema

Responds, sign-in requiredStatus and history

The server answered 3 hours ago but needs an account or API key, so we could not list its tools.

Pricing
Freemium
Platforms
Web, API, CLI
Runs
Locally or Remotely
Access
Needs an account or API key
Version
0.5.3
Listing updated
2 days ago

About model2data studio

model2data studio is a freemium MCP server for databases. It can run locally on your machine or as a hosted remote server.

model2data studio starts from a schema, never from your data. You write a model as YAML or DBML, paste CREATE TABLE scripts from systems such as Snowflake, BigQuery or PostgreSQL, or import a dbt project, and the studio generates rows where every foreign key points to a real parent row. The same seed gives the same rows on every run.

The MCP server lets Claude work inside it. The site's demo turns one sentence about a coffee roastery into four tables with 5,440 rows, three metrics and a dashboard in under a minute, with each file checked by the studio before it is saved. Claude can read projects, write and check a model, add metrics and see their known values, build dashboards and preview up to fifty generated rows per table. It cannot delete or share projects or manage API keys.

Beyond rows, the studio produces a dbt project that runs under dbt build, optional messy data with the tests that should fail, and an exact expected value for each metric to use as an acceptance test. The Claude connector signs in with OAuth on every plan; the local stdio server for CI needs a Pro API key. The studio is hosted in Frankfurt.

Install

Run in a terminal

claude mcp add --transport http model2data-studio https://studio.jbanalytica.com/mcp

Add to Settings → Connectors → Add custom connector

https://studio.jbanalytica.com/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "model2data-studio": {
      "url": "https://studio.jbanalytica.com/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "model2data-studio": {
      "type": "http",
      "url": "https://studio.jbanalytica.com/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "model2data-studio": {
      "serverUrl": "https://studio.jbanalytica.com/mcp"
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "model2data-studio": {
      "type": "http",
      "url": "https://studio.jbanalytica.com/mcp"
    }
  }
}

Configuration

  • MODEL2DATA_STUDIO_KEYA studio API key, created in the studio's account menu (Pro plan).Required
  • MODEL2DATA_STUDIO_URLThe studio to talk to. Only for a self-hosted studio.

What it does

Connected fake data
Every key joins to a real row, with repeatable seeded output.
Claude connector
Claude builds models, metrics and dashboards through the studio's tools.
Messy data mode
Plans realistic defects and lists the dbt tests that should fail.
dbt project output
Seeds, staging models and tests that run under dbt build.
Known metric values
The expected answer for each metric, shipped as an acceptance test.
Shareable dashboards
Dashboard-as-code with comments on tiles, no account needed to view.

Good for

  • Build and test a dbt project before source access arrives
  • Show a client a working stack with no client data
  • Agree metric values before anyone writes SQL
  • Practise finding data-quality defects
  • Keep CI fixtures in sync with a committed model

Pricing

Freemium

Free plan; Pro 99 EUR/month or 990 EUR/year excl. VAT; Team coming soon

Prices change. Check jbanalytica.com before you buy.

model2data studio FAQ

Does my data leave my machine?

Only the schema goes to the studio, hosted in Frankfurt. No production rows, connection strings or credentials go in.

What is free?

The editor, diagram, previews and the Claude connector, with 100 rows per table and 2 projects, no card or time limit.

What does Pro cost?

99 EUR a month or 990 EUR a year excluding VAT, with 50,000 rows per table.

Does it need an API key?

The Claude connector signs in and approves with no key; the local MCP server needs a studio API key from a Pro account.

Is there a team plan?

Team is listed as coming soon at 399 EUR a month for up to 5 users; Business is priced in a conversation.

Is model2data studio free?

model2data studio has a free plan, with paid plans for more usage or features.

How do I add model2data studio to Claude Code?

Run this command in your terminal: claude mcp add --transport http model2data-studio https://studio.jbanalytica.com/mcp

What are the best alternatives to model2data studio?

The closest alternatives to model2data studio are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to model2data studio

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data