Package Exports

@j0kz/db-schema-mcp
@j0kz/db-schema-mcp/dist/index.js

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@j0kz/db-schema-mcp) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

@j0kz/db-schema-mcp

Design database schemas with migrations and relationship analysis

🎉 What's New in v1.0.26

📚 Comprehensive Examples: New example files in examples/db-schema/
🎯 Better Error Messages: Improved validation and error handling
✅ Production Ready: Enhanced schema design, migration generation, and ER diagram creation

🚀 Quick Start

⭐ Option 1: Install ALL 8 Tools (Recommended)

Get the complete suite with ONE command:

Claude Code:

# Mac/Linux
curl -fsSL https://raw.githubusercontent.com/j0kz/mcp-agents/main/install-all.sh | bash

# Windows (PowerShell)
irm https://raw.githubusercontent.com/j0kz/mcp-agents/main/install-all.ps1 | iex

Cursor/Windsurf:

# Download complete config
curl -o ~/.cursor/mcp_config.json https://raw.githubusercontent.com/j0kz/mcp-agents/main/mcp_config_all.json

# Or for Windsurf
curl -o ~/.windsurf/mcp_config.json https://raw.githubusercontent.com/j0kz/mcp-agents/main/mcp_config_all.json

Option 2: Install Only This Tool

Claude Code:

claude mcp add db-schema "npx @j0kz/db-schema-mcp" --scope user

Cursor/Windsurf: Add to mcp_config.json:

{
  "mcpServers": {
    "db-schema": {
      "command": "npx",
      "args": ["@j0kz/db-schema-mcp"]
    }
  }
}

Start Using Immediately

After setup, just chat naturally with your AI:

💬 You: "Design a schema for an e-commerce app"
🤖 AI: *Creates schema* Tables: users, products, orders, order_items with relationships, indexes, constraints. Includes migration SQL...

💬 You: "Generate migrations for PostgreSQL"
🤖 AI: *Analyzes changes* Created: 001_create_users.sql, 002_add_indexes.sql, 003_add_constraints.sql with rollback support...

💬 You: "Optimize this database schema"
🤖 AI: Suggestions: Add index on user_id (used in 80% of queries), denormalize order_total, partition orders by date...

✨ Features

🗄️ Schema Design - Create optimized database structures 🔄 Migration Generation - SQL migrations with up/down scripts 🔗 Relationship Analysis - Detect and fix relationship issues ⚡ Performance Optimization - Index suggestions and query optimization

📦 Complete @j0kz MCP Suite

Get all 8 professional development tools - install individually or all at once:

# 🎯 Code Quality Suite
npx @j0kz/smart-reviewer-mcp      # AI code review
npx @j0kz/test-generator-mcp      # Auto-generate tests
npx @j0kz/refactor-assistant-mcp  # Refactoring help

# 🏗️ Architecture & Design
npx @j0kz/architecture-analyzer-mcp  # Architecture analysis
npx @j0kz/api-designer-mcp           # API design
npx @j0kz/db-schema-mcp              # Database schemas

# 📚 Documentation & Security
npx @j0kz/doc-generator-mcp       # Auto-generate docs
npx @j0kz/security-scanner-mcp    # Security scanning

👉 View complete collection on GitHub

🎯 How It Works

Install once - Run the setup command for your editor
Restart editor - Reload to activate the MCP
Chat naturally - Just ask your AI assistant to help
Get results - The MCP tools work behind the scenes

No configuration files, no complex setup, no API keys needed!

🔧 Editor Support

Editor	Status	Notes
Claude Code	✅ Full support	Recommended
Cursor	✅ Full support	Native MCP
Windsurf	✅ Full support	Built-in MCP
Roo Code	✅ Full support	MCP compatible
Continue	✅ Full support	MCP plugin
Zed	✅ Full support	MCP support

Any MCP-compatible editor works!

❓ Troubleshooting

MCP not showing up?

Restart your editor after installation
Check: claude mcp list (Claude Code) to verify connection

Commands not working?

Make sure Node.js is installed (node --version)
Try reinstalling: Remove and re-add the MCP

Still stuck?

📄 License

MIT © j0KZ

Explore more tools: github.com/j0KZ/mcp-agents | npm: @j0kz