AI-Assisted Data Generation: Use Claude or Your AI Agent to Generate Mock Data

Kwasi Baidoo — Fri, 05 Jun 2026 08:19:03 +0000

Imagine asking your AI assistant to generate a complete test database and having it happen instantly without switching tools.

"Generate test data for a users table with 1,000 rows, a posts table with 5,000 rows, and ensure every post references a valid user."

The AI handles it. You get back SQL you can import directly.

This is now possible with FakerForge's MCP integration.

What Is MCP?

MCP (Model Context Protocol) is a standard for connecting AI agents to external tools and services. Tools like Claude, Cursor, and other MCP-capable clients can invoke these external services directly.

FakerForge exposes an MCP server. This means:

Your AI agent (Claude, Cursor, etc.) can call FakerForge functions
You can ask the agent to generate data in natural language
The agent connects to FakerForge, runs generation, and returns results
All without leaving your editor

Setting Up MCP With FakerForge

According to FakerForge's MCP documentation, the setup process is:

Step 1: Create an MCP Token

Go to FakerForge's MCP token page and create a token. According to the docs:

"Copy it immediately. Store securely in your client config."

This token authenticates your AI agent with FakerForge.

Step 2: Configure Your MCP Client

Add FakerForge to your MCP client config (VS Code, Cursor, Claude Code, or Windsurf):

{
    "mcpServers": {
        "fakerforge": {
            "url": "https://your-domain/mcp/fakerforge",
            "headers": {
                "Authorization": "Bearer YOUR_TOKEN"
            }
        }
    }
}

Step 3: Verify Connectivity

The docs recommend testing with read-only tools first:

"First MCP calls: list-schemas, get-codebase-schema, list-mocks. These verify auth and connectivity before mutation tools."

Once you can list schemas, you're connected.

Real Workflow: Generating Data With Claude

Now you can ask Claude to generate data directly from your editor.

Example 1: Simple Data Generation

User: "I have a users table with id, email, name, and country. 
Generate 100 rows of realistic test data as SQL."

Claude calls FakerForge's MCP tools to:

Parse your schema
Generate 100 rows
Return SQL

You get back:

INSERT INTO users (id, email, name, country) VALUES
(1, 'john.smith@example.com', 'John Smith', 'US'),
(2, 'maria.rodriguez@example.com', 'Maria Rodriguez', 'MX'),
...

Example 2: Multiple Tables With Relationships

User: "Generate test data for a blog platform:
- users table: 50 rows
- posts table: 200 rows (each post references a valid user)
- comments table: 500 rows (each comment references a valid post)
Make sure all foreign keys are valid."

Claude:

Parses your schema (detects the relationships)
Calls FakerForge's generation with row counts
FakerForge handles relationship-aware generation
Returns SQL with valid FK references

You get consistent, valid data without writing anything.

Example 3: List Existing Schemas

User: "What schemas do I have in FakerForge?"

Claude calls list-schemas and returns your existing schemas, letting you reuse them rather than recreating.

Why This Matters

Context Stays in Your Editor

Before MCP, generating data required:

Go to fakerforge.com
Paste schema
Set row counts
Download
Come back to editor

Now: Ask Claude in your editor. Get SQL back. Paste.

Natural Language Interface

Instead of learning FakerForge's UI, you describe what you want in English. Claude translates to the right FakerForge operations.

Integration With Your Workflow

You're already using Claude/Cursor for coding. MCP makes data generation part of that same conversation:

You: "Here's my schema (paste). Generate 1,000 rows of realistic test data."

Claude: "I'll generate that for you."
[Calls FakerForge MCP tools]
"Here's your data: [SQL]"

You: "Perfect, paste it into seed.sql for me"

Claude: "Done. Want me to run the import?"

AI Agents Can Drive Automation

A CI/CD agent or code migration tool can call FakerForge directly via MCP:

# CI/CD pipeline calls Claude agent
agent.ask("Generate test data for schema.sql with 10,000 rows")

# Claude uses FakerForge MCP tools
# Generates data
# CI/CD gets SQL back
# Imports into test database

Security Guidelines

FakerForge's docs emphasize security for MCP:

"Never commit MCP tokens. Rotate tokens on team/member changes. Use least privilege and environment separation."

Best practices:

Store tokens securely — use environment variables or secure credential managers
Rotate on team changes — when someone leaves, revoke their token
One token per integration — don't share a single token across multiple systems
Least privilege — create tokens with only the permissions needed

Practical Example: Setting Up in Cursor

Cursor is VS Code with integrated AI. Here's how to add FakerForge MCP:

Step 1: Create your FakerForge MCP token

Step 2: Open .cursor/mcp.json in your project:

{
  "mcpServers": {
    "fakerforge": {
      "url": "https://api.fakerforge.com/mcp/fakerforge",
      "headers": {
        "Authorization": "Bearer sk-ff_your_token_here"
      }
    }
  }
}

Step 3: In Cursor chat, ask:

I need to generate seed data for my database. 
Here's my schema (paste schema).
Generate 5,000 rows and return as SQL.

Step 4: Cursor calls FakerForge MCP tools, Claude generates data

Step 5: Copy the SQL into your seed file

Done.

What MCP Tools Are Available?

According to the docs, FakerForge exposes tools for:

list-schemas — list all your schemas
get-codebase-schema — retrieve a specific schema
list-mocks — list your mock APIs
Plus mutation tools for generation and mocking

The docs recommend starting with read-only tools (list, get) to verify connectivity, then moving to mutation tools (generate, create).

Common Use Cases

CI/CD Pipeline Automation

Your CI/CD pipeline needs fresh test data:

- name: Generate test data via MCP
  run: |
    claude --mcp fakerforge generate \
      --schema schema.sql \
      --customers 100000 \
      --invoices 500000

Schema Evolution

You modify your schema. Claude automatically regenerates your seed data:

User: "I added a 'phone_number' column to users. 
Update my test data to include it."

Claude: [Detects schema change, regenerates with new field]

Demo Data

Spinning up a demo environment for a customer:

User: "Generate a realistic demo database 
with 100 customers, 1,000 orders, all relationships valid."

Claude: [Generates, returns SQL]

The Docs Say This Is the Future

FakerForge's MCP documentation positions it clearly: AI agents should be able to generate data as easily as developers can today.

The current workflow is:

UI-based (go to website, use UI)
Manual (you decide parameters)
Slow (multiple steps)

MCP-enabled workflow is:

Chat-based (ask in natural language)
Automated (AI decides parameters based on intent)
Fast (one-step)

Bottom Line

If you're already using Claude, Cursor, or similar tools, adding FakerForge's MCP integration is a no-brainer.

Generate test data without leaving your editor. Ask in natural language. Get SQL back. Done.

Get your MCP token and add it to your editor config.

Your data generation workflow just got 10x faster.

DEV Community: Kwasi Baidoo