SeedWeaver
Supports parsing MySQL CREATE TABLE DDL statements to infer schema, relationships, and constraints for realistic test data generation.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@SeedWeaver Generate 50 users and 200 orders for this schema."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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_idpointing 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 NULLis honored.Reads your real schema β paste Postgres/MySQL
CREATE TABLEDDL directly, no manual config.Realistic values β names, emails, addresses, companies, dates, decimals, enums.
Outputs what you need β SQL
INSERTstatements, JSON, or CSV.
Related MCP server: mockhero
Install
npx -y seedweaver-mcpAdd to your MCP client config (Claude Desktop / Cursor / Windsurf):
{
"mcpServers": {
"seedweaver": {
"command": "npx",
"args": ["-y", "seedweaver-mcp"]
}
}
}Tools
Tool | What it does |
| 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 coherent test data. Returns SQL |
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):
{
"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 β $19/mo
Activate by setting your license key:
{
"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.
Available Tools
2 toolsanalyze_schemaA
Parse a database schema (SQL CREATE TABLE statements or a JSON schema) and report its tables, columns, relationships, and the order seed data would be generated in. Use this first to confirm SeedWeaver understands the schema correctly.
Inputs: schema (required).
generate_seed_dataA
Generate realistic, referentially-coherent test data from a database schema. Foreign keys resolve to real generated primary keys, unique constraints are respected, and values are realistic (names, emails, dates). Accepts SQL DDL or a JSON schema. Returns INSERT statements, JSON, or CSV.
Inputs: schema (required), rows, seed, format.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelogβ¦
TDQS
Scored across 2 tools
The two tools have entirely distinct purposes: one for analyzing/validating schema understanding, the other for generating data. No overlap or ambiguity.
Both tools follow the consistent verb_noun pattern (analyze_schema, generate_seed_data), making their actions and targets clear.
With only 2 tools, the server is minimal but still covers its core purpose. It could benefit from a few more tools (e.g., configuration, validation), but the count is acceptable for a focused utility.
The tool surface covers the essential workflow: analyze schema, then generate data. Minor gaps like customizing data types or revalidating are absent but not critical for the stated purpose.
Maintenance
Related MCP Connectors
Generate realistic, FK-consistent synthetic test data for your databases from your AI assistant.
Generate realistic relational test data β 156 field types, 22 locales, JSON/CSV/SQL, free previews.
ER diagrams from SQL, Prisma or ORM models. One tool, no account, nothing stored.
The AI that understands raw data: Schema over your tables and databases, as MCP tools.
Related MCP Servers
- AlicenseBqualityDmaintenanceGenerates realistic mock data using Faker.js for database seeding, API testing, and development environments. Supports person/company data, custom patterns, multi-locale generation, and structured datasets with referential integrity.456 npm7MIT
- AlicenseAqualityDmaintenanceGenerate realistic relational test data with 156 field types, 22 locales, and foreign key integrity. One API call seeds your entire database.51MIT
- AlicenseAqualityBmaintenanceGenerates schema-compliant mock data from OpenAPI JSON Schema definitions using AI, enabling seamless testing without manual fixtures.6198 npm10MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to generate realistic, relationship-preserving test data from Seedbase projects into databases.47 npmMIT