Allows natural language interaction with MariaDB databases, enabling users to perform queries, explore database schemas, and visualize data.
Provides a natural language interface for MySQL databases, supporting schema exploration, data visualization, and instant query execution.
Enables querying and schema analysis of PostgreSQL databases through natural language commands and provides tools for data visualization.
Allows users to interact with SQLite databases using natural language, providing capabilities for schema browsing and data analysis.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Database MCPList the top 5 customers by total revenue this month"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Database MCP - Natural Language Database Interface
A modern web application that lets you interact with SQL databases using natural language, powered by the Model Context Protocol (MCP).
Features
Natural Language Queries: Ask questions in plain English, get results instantly
Multi-Database Support: PostgreSQL, MySQL, MariaDB, MSSQL, SQLite
Rich Visualizations: Tables, charts, and formatted code blocks
Schema Explorer: Browse database structure with an intuitive sidebar
Dark & Light Modes: Modern design with light/dark theme support
Responsive Design: Works on desktop, tablet, and mobile
Prerequisites
Node.js 18+
A database (PostgreSQL, MySQL, MSSQL, or SQLite)
LLM API key (Groq, OpenAI, or compatible endpoint)
Setup & Installation
1. Install Dependencies
2. Configure Environment
Copy .env.example to .env and update with your credentials:
Then edit .env with:
LLM_API_URL: Your LLM API endpoint (e.g., Groq, OpenAI)LLM_API_KEY: Your API keyLLM_MODEL: Model name (e.g., mixtral-8x7b-32768)ENCRYPTION_KEY: A 32-character random key for production
3. Run Development Server
The application will start at http://localhost:3000
Available Scripts
Supported Databases
Database | Status |
PostgreSQL | ✅ |
MySQL / MariaDB | ✅ |
SQL Server | ✅ |
SQLite | ✅ |
Architecture
Key Components:
Frontend (
public/): Interactive UI with theme supportServer (
src/server.ts): Express API and MCPTools (
src/mcp/): MCP protocol implementationProviders (
src/providers/): Database adaptersScanner (
src/scanner/): Database schema analysisEncryption (
src/utils/encryption.ts): Credential encryption
License
MIT