MCP Database Server
A Model Context Protocol (MCP) server that provides tools for interacting with a SQLite database.
Features
- query_database: Execute SQL queries (SELECT, INSERT, UPDATE, DELETE)
- import_csv: Import CSV files into database tables
- list_tables: List all tables with their schemas
Setup
npm install
npm run build
Usage
With Claude Desktop
Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json):
{
"mcpServers": {
"database": {
"command": "node",
"args": ["/path/to/mcp-test/dist/index.js"],
"env": {
"DB_PATH": "/path/to/your/database.db"
}
}
}
}
Development
npm run dev
Tools
query_database
Execute SQL queries on the database.
{
"query": "SELECT * FROM users WHERE id = ?",
"params": ["1"]
}
import_csv
Import a CSV file into a table.
{
"file_path": "/path/to/data.csv",
"table_name": "my_table",
"delimiter": ","
}
list_tables
List all tables and their schemas. No parameters required.
Environment Variables
DB_PATH: Path to the SQLite database file (default:./data.db)
