Back to the catalog

io.github.FixtureForge/seedweaver-mcp

Schema-aware relational test data generator with working foreign keys, for any MCP client.

Open source Open in the app JSON README (API)

About

Schema-aware relational test data generator with working foreign keys, for any MCP client.

Details

Kind
MCP servers
Topic
No topic detected
Publisher
fixtureforge
Origin
official
Category
ferramentas
Transport
local
Version
0.2.0
Last push
2026-05-29T11:06:11Z
Repository state
ativo
Language
TypeScript
Added
2026-08-29 03:01:55
Updated
2026-08-29 03:01:55
Origin id
io.github.FixtureForge/seedweaver-mcp

README

# SeedWeaver ๐ŸŒฑ

**Generate realistic, referentially-coherent test data from your real database schema โ€” straight from Claude, Cursor, or any MCP client.**

Paste your `CREATE TABLE` SQL (or a JSON schema) and SeedWeaver generates seed data where **foreign keys actually resolve to real primary keys**, **unique constraints are respected**, and values are realistic (names, emails, dates, decimals). Unlike generic mock-data tools that spit out statistically random junk, SeedWeaver understands the *relationships* in your schema.

> Ask your AI: *"Generate 50 users and 200 orders for this schema"* โ€” and get INSERTs you can run immediately, with every `order.user_id` pointing at a user that exists.

---

## Why SeedWeaver

Most "fake data" tools (Faker wrappers, random generators) give you isolated rows with no awareness of your schema. The moment you have foreign keys, you're back to hand-wiring relationships. SeedWeaver:

- **Resolves foreign keys** โ€” referenced tables are generated first (topological ordering), and FK columns point at real generated keys.
- **Respects constraints** โ€” unique columns stay unique, primary keys are unique, `NOT NULL` is honored.
- **Reads your real schema** โ€” paste Postgres/MySQL `CREATE TABLE` DDL directly, no manual config.
- **Realistic values** โ€” names, emails, addresses, companies, dates, decimals, enums.
- **Outputs what you need** โ€” SQL `INSERT` statements, JSON, or CSV.

## Install

```bash
npx -y seedweaver-mcp
```

Add to your MCP client config (Claude Desktop / Cursor / Windsurf):

```json
{
  "mcpServers": {
    "seedweaver": {
      "command": "npx",
      "args": ["-y", "seedweaver-mcp"]
    }
  }
}
```

## Tools

| Tool | What it does |
|------|--------------|
| `analyze_schema` | Parse a schema (SQL DDL or JSON) and report tables, columns, relationships, and generation order. Run this first to confirm SeedWeaver reads your schema correctly. |
| `generate_seed_data` | Generate coherent test data. Returns SQL `INSERT`s (default), JSON, or CSV. |

## Examples

**From SQL DDL:**

```
Generate 20 rows of test data for:

CREATE TABLE users (
  id UUID PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  full_name VARCHAR(100),
  created_at TIMESTAMP
);
CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  user_id UUID NOT NULL REFERENCES users(id),
  total DECIMAL(10,2),
  status VARCHAR(20)
);
```

Every generated `orders.user_id` will be a real `users.id`.

**From a JSON schema** (gives you fine control โ€” enums, ranges, per-table row counts):

```json
{
  "tables": [
    {
      "name": "users",
      "rows": 20,
      "columns": [
        { "name": "id", "type": "uuid", "primaryKey": true },
        { "name": "email", "type": "email", "unique": true },
        { "name": "name", "type": "fullName" }
      ]
    },
    {
      "name": "orders",
      "rows": 80,
      "columns": [
        { "name": "id", "type": "serial", "primaryKey": true },
        { "name": "user_id", "type": "fk", "references": "users.id" },
        { "name": "total", "type": "decimal", "min": 5, "max": 500 },
        { "name": "status", "type": "enum", "values": ["pending", "paid", "shipped"] }
      ]
    }
  ]
}
```

Supported column types: `uuid`, `serial`, `int`, `decimal`, `boolean`, `email`, `fullName`, `firstName`, `lastName`, `username`, `phone`, `address`, `city`, `country`, `company`, `url`, `word`, `sentence`, `paragraph`, `date`, `datetime`, `enum`, `fk`.

---

## Free vs. Pro

The free tier is fully functional for small schemas. **Pro** removes the limits and adds the features you need for real projects and CI.

| | Free | **Pro** |
|---|------|---------|
| Tables per schema | 2 | **Unlimited** |
| Rows per table | 50 | **Unlimited** |
| Output formats | SQL, JSON | **+ CSV** |
| Deterministic seeds (reproducible data) | โ€” | **โœ“** |
| Custom locales | โ€” | **โœ“** |
| Use in CI / automation | โ€” | **โœ“** |

**[โ†’ Get SeedWeaver Pro](https://your-gumroad-url.gumroad.com/l/seedweaver)** โ€” $19/mo

Activate by setting your license key:

```json
{
  "mcpServers": {
    "seedweaver": {
      "command": "npx",
      "args": ["-y", "seedweaver-mcp"],
      "env": { "SEEDWEAVER_LICENSE": "your-key-here" }
    }
  }
}
```

---

## License

The SeedWeaver MCP server is MIT licensed and free to run. Pro features are unlocked with a paid license key. Built with the [Model Context Protocol](https://modelcontextprotocol.io).

More