# 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`)