mcp-for-database

MCP Database Console is a web-based interface that translates natural language prompts into database queries. Built around the MCP-DB Connector, it enables you to ask questions in plain English and receive SQL-backed results from your configured databases (such as SQLAlchemy-compatible databases, Snowflake, or SQLite). The frontend guides the user through connecting to a database, composing natural language queries, and viewing results in formatted tables, with helpful error messages when needed. In development mode, a mock MCP server is provided so you can exercise the interface without a live MCP-DB Connector.

To use the tool, start the mock MCP server (port 8000 by default) and then run the Next.js dev server (port 3000 by default). The mock server exposes endpoints for test-connection and query so you can validate interactions before wiring up to a real database.

Prerequisites:

• Node.js and npm installed
• Git installed

Step 1: Clone the repository

• git clone https://github.com/your-org/mcp-for-database.git
• cd mcp-for-database

Step 2: Install dependencies

• npm install

Step 3: Run the mock MCP server (optional for local development)

• npm run mock:mcp

Step 4: Start the frontend dev server

• npm run dev

Step 5: Open the application

• Visit http://localhost:3000/db-console

Notes:

• If port 8000 (mock MCP) is in use, set MOCK_MCP_PORT to another port and update MCP_SERVER_URL in .env.local as needed.
• The mock server logs requests to help with debugging.

Tips and common issues:

• Environment variables: MOCK_MCP_PORT (port for the mock MCP server), MCP_SERVER_URL (base URL for MCP API). Adjust as needed when running locally.
• If you’re wiring up a real MCP-DB Connector, configure the MCP_SERVER_URL to point to your connector and ensure authentication is set up (JWT/RBAC may be in use as indicated by the project’s authentication features).
• When testing, the mock server provides endpoints like /test-connection and /query to simulate real interactions.
• For contributors: use npm run dev for frontend hot-reloading and npm run mock:mcp to exercise MCP interactions without a real backend.