MCP Database Server

# 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 ```bash npm install npm run build ``` ## Usage ### With Claude Desktop Add to your Claude Desktop config (`~/Library/Application Support/Claude/claude_desktop_config.json`): ```json { "mcpServers": { "database": { "command": "node", "args": ["/path/to/mcp-test/dist/index.js"], "env": { "DB_PATH": "/path/to/your/database.db" } } } } ``` ### Development ```bash npm run dev ``` ## Tools ### query_database Execute SQL queries on the database. ```json { "query": "SELECT * FROM users WHERE id = ?", "params": ["1"] } ``` ### import_csv Import a CSV file into a table. ```json { "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`)