MCP
MCP server that generates referentially intact synthetic PostgreSQL data
- Pricing
- Freemium
- Platforms
- CLI
- Runs
- Locally
- Version
- 0.1.14
- Listing updated
- today
About MCP
MCP is a freemium MCP server for databases. It runs locally on your machine and is started by your AI client.
Weavori points at a Postgres database, introspects the schema and produces a synthetic replica, and this server exposes that from an assistant. It is the Weavori command line (@weavori/cli on npm) over stdio, so a Weavori API key is required for all commands, and a default PostgreSQL connection string can be supplied as a fallback.
Generation is schema-driven with no config file: column names and types map to fitting generators, so first_name yields a name and zip yields a ZIP. It matches the shape of your real data (a 70% active status stays 70% active), keeps every foreign key pointing at a generated parent, and avoids contradictions such as an order paid before its customer signed up. Eight built-in functions let you add derived columns, and you can supply your own values as CSV.
The site gives July 2026 benchmarks against PostgreSQL 17: 100,000 rows across 14 tables in 12.4 seconds via COPY. The free plan allows 2,000 rows a month with a 14-day Pro trial; Pro raises that to 1 million rows. Only PostgreSQL is mentioned.
Install
Run in a terminal
claude mcp add mcp --env WEAVORI_API_KEY='<WEAVORI_API_KEY>' -- npx -y @weavori/cliAdd to claude_desktop_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@weavori/cli"
],
"env": {
"WEAVORI_API_KEY": "<WEAVORI_API_KEY>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@weavori/cli"
],
"env": {
"WEAVORI_API_KEY": "<WEAVORI_API_KEY>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@weavori/cli"
],
"env": {
"WEAVORI_API_KEY": "<WEAVORI_API_KEY>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@weavori/cli"
],
"env": {
"WEAVORI_API_KEY": "<WEAVORI_API_KEY>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"mcp": {
"command": "npx",
"args": [
"-y",
"@weavori/cli"
],
"env": {
"WEAVORI_API_KEY": "<WEAVORI_API_KEY>"
}
}
}
}Configuration
WEAVORI_API_KEYWeavori API key. Authentication is required for all commands (ADR 0033); used in CI where there is no interactive login.RequiredWEAVORI_DATABASE_URLDefault PostgreSQL connection string (DSN). Optional fallback when a tool call does not pass a DSN explicitly.
What it does
- Schema inference
- Maps column names and types to generators without a config file.
- Distribution-aware output
- Reproduces the real proportions of values in your data.
- Foreign-key integrity
- Every foreign key points at a generated parent row.
- Formula columns
- Eight built-in functions create derived columns, with errors caught at plan time.
- Bring your own CSV
- Supply real values such as SKUs or regions and map them to columns.
- Direct export
- Write data straight into a target database using COPY.
Good for
- Seed a staging database with realistic data without copying production
- Create test data for a new schema in minutes
- Keep queries and indexes behaving like production in CI
- Add known product names or regions through CSV datasets
Pricing
Freemium
Free: 2,000 rows/month with a 14-day Pro trial; Pro 1M rows/month (price not published)
Prices change. Check weavori.com before you buy.
MCP FAQ
Is there a free tier?
Yes, 2,000 rows a month, unlimited tables and runs, plus a 14-day Pro trial with no credit card.
Is an API key required?
Yes. The registry entry says authentication is required for all commands.
How fast is it?
On the site's July 2026 benchmark, 100,000 rows across 14 tables took 12.4 seconds.
Does it support other databases?
Only PostgreSQL is described.
Is MCP free?
MCP has a free plan, with paid plans for more usage or features.
How do I add MCP to Claude Code?
Run this command in your terminal: claude mcp add mcp --env WEAVORI_API_KEY='<WEAVORI_API_KEY>' -- npx -y @weavori/cli
What are the best alternatives to MCP?
The closest alternatives to MCP are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.
Alternatives to MCP

REA
MCP serverCLI and MCP server that lets coding agents reverse engineer apps and binaries
Runs locally- Open source
- 464K GitHub stars
- Developer tools

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

GitHub
MCP serverOfficial MCP server connecting AI assistants to GitHub repos, issues and workflows
Not checked yet- Remote
- Open source
- 34.5K GitHub stars
- Developer tools

Serena MCP: the IDE for your agent
MCP serverMCP toolkit giving coding agents symbol-level code retrieval and editing
Runs locally- Open source
- 31.5K GitHub stars
- Developer tools

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Ouroboros
MCP serverSpec-first layer that pins requirements and verifies results of AI coding agent work
Runs locally- Open source
- 6.4K GitHub stars
- Developer tools