No2SQL 1.0.2

No2SQL

No2SQL is an MCP server and NuGet package that helps you move from MongoDB to SQL by:

• discovering collections and relationship candidates,
• generating SQL schema scripts,
• generating SQL seed (INSERT) statements,
• producing ER diagrams in Mermaid, PlantUML, and GraphViz DOT formats.

Who This Is For

• Teams migrating from MongoDB to relational databases
• Engineers documenting NoSQL structures in ERD form
• AI-assisted workflows where Copilot can call data-migration tools through MCP

Quick Start

1. Configure MongoDB connection

Set your MongoDB connection string with either:

1. Environment variable NO2SQL_MONGO (recommended)
2. No2SQL/appsettings.json connection string ConnectionStrings:MongoDb

Example format:

mongodb+srv://<username>:<password>@<cluster-host>/<database>?retryWrites=true&w=majority

Installing the No2SQL MCP Server

The No2SQL MCP server is distributed as a standalone executable inside a NuGet package.
You do NOT need .NET installed and you do NOT need a .NET project.

1. Download the package

Option A — Using curl

curl -L https://www.nuget.org/api/v2/package/No2SQL/1.0.2 -o No2SQL.1.0.2.nupkg

Option B — Using PowerShell

Invoke-WebRequest https://www.nuget.org/api/v2/package/No2SQL/1.0.2 -OutFile No2SQL.1.0.2.nupkg

Option C — Download manually

Visit:
https://www.nuget.org/packages/No2SQL
and click Download package.

2. Extract the package

A .nupkg is a ZIP archive:

unzip No2SQL.1.0.2.nupkg -d no2sql

Executables will be located under:

/tools/win-x64/No2SQL.exe
/tools/linux-x64/No2SQL
/tools/osx-arm64/No2SQL

3. Configure your MCP client

Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "no2sql": {
      "command": "path/to/no2sql/tools/win-x64/No2SQL.exe"
    }
  }
}

VS Code MCP Extension

"mcp.servers": {
  "no2sql": {
    "command": "path/to/no2sql/tools/win-x64/No2SQL.exe"
  }
}

GitHub Copilot MCP

{
  "mcpServers": {
    "no2sql": {
      "command": "path/to/no2sql/tools/win-x64/No2SQL.exe"
    }
  }
}

4. Try it in Copilot Chat

Example prompts:

• "Use No2SQL to list my MongoDB databases."
• "Infer relationships for database mydb."
• "Generate SQL schema for database mydb."
• "Generate Mermaid ERD for mydb using SQL source."
• "Generate SQL INSERT statements for collection orders in mydb."

MCP Tools Exposed

• TestConnectivity: Verify MCP server connectivity.
• ListDatabases: List available databases (respects allowlist policy).
• ListInferredRelationships: List ID-like fields by collection.
• CompareIdFieldsToIds: Infer relationships by matching ID-like fields to _id values.
• GenerateSqlSchema: Generate SQL schema from inferred relationships.
• GenerateSqlSchemaAdvanced: Generate SQL schema with optional relationship overrides.
• GenerateSeedersForCollection: Generate SQL INSERT seed statements for one collection.
• GenerateErdMermaid: Generate Mermaid ERD (source: sql, mongo, auto).
• GenerateErdPlantUml: Generate PlantUML ERD (source: sql, mongo, auto).
• GenerateErdDot: Generate GraphViz DOT ERD (source: sql, mongo, auto).

Security Guardrails

No2SQL includes input validation and database access guardrails.

Environment variables:

• NO2SQL_ALLOWED_DATABASES: Optional comma-separated database allowlist.
• NO2SQL_BLOCK_SYSTEM_DATABASES: Defaults to true; blocks admin, config, local.

Tool inputs are validated for:

• identifier format and length,
• diagram source values (sql, mongo, auto),
• relationship override fields,
• prompt-injection style marker patterns.

Recommended production baseline:

1. Set NO2SQL_ALLOWED_DATABASES to a strict allowlist.
2. Keep NO2SQL_BLOCK_SYSTEM_DATABASES=true.

Build, Test, Publish

Build solution:

dotnet build No2SQL.sln

Run test harness:

dotnet run --project No2SQL.Test

Pack NuGet:

dotnet pack -c Release

Publish NuGet package:

dotnet nuget push **/bin/Release/*.nupkg --api-key <your-api-key> --source https://api.nuget.org/v3/index.json

Local Test Defaults

No2SQL.Test/Program.cs supports environment variable overrides:

• NO2SQL_TEST_DATABASE: Database used when none is supplied.
• NO2SQL_TEST_COLLECTION: Collection used by --test-stream when none is supplied.
• NO2SQL_TEST_ROWS_PER_CHUNK: Optional chunk-size override for stream seeder checks.
• NO2SQL_TEST_LIMIT: Optional max document count override for stream seeder checks.
• NO2SQL_TEST_BATCH_SIZE: Optional Mongo cursor batch size override for stream seeder checks.

CLI arguments take precedence over environment variables.

Contributions

Forks and derivative works are welcome under the MIT License.

Changes to the official No2SQL repository are accepted at the maintainer's discretion. Submitting a pull request does not guarantee inclusion.

License

No2SQL is licensed under the MIT License.

Copyright (c) 2026 Preet Talati

"No2SQL" is a trademark of Preet Talati.