@vibesql/mcp

MCP server that connects your AI coding tool to a VibeSQL PostgreSQL database. One command, 9 tools, zero config.

Quick Start

npx vibesql-micro       # start database on :5173
npx @vibesql/mcp        # start MCP server

Claude Code Setup

Add to .claude/settings.json:

{
  "mcpServers": {
    "vibesql": {
      "command": "npx",
      "args": ["@vibesql/mcp"]
    }
  }
}

Custom URL:

{
  "mcpServers": {
    "vibesql": {
      "command": "npx",
      "args": ["@vibesql/mcp", "--url", "http://10.0.0.5:5173"]
    }
  }
}

Tools

| Tool | Description | |------|-------------| | query | Execute any SQL query (DDL + DML) | | list_tables | List all tables in the database | | describe_table | Get column schema for a table | | table_data | Browse rows with pagination | | create_table | Create a table (validated, no semicolons) | | insert_row | Insert a row from JSON column-value pairs | | help | Help on a VibeSQL topic | | help_products | Product family overview | | help_architecture | Architecture patterns |

The query tool is intentionally unrestricted -- it can execute any valid SQL including DROP, DELETE, and TRUNCATE. This is a local development tool.

Environment

Set VIBESQL_URL to override the default http://localhost:5173. The --url CLI flag takes precedence over the env var.

License

Apache-2.0