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)