# database-updater MCP Server
[![database-updater-MCP-Server MCP server](https://glama.ai/mcp/servers/AnuragRai017/database-updater-MCP-Server/badges/score.svg)](https://glama.ai/mcp/servers/AnuragRai017/database-updater-MCP-Server)

A Model Context Protocol server for updating databases from CSV and Excel files.

## Features

### Tools
- `update_database` - Update database from CSV/Excel files
  - Supports CSV and Excel (.xlsx, .xls) file formats
  - Compatible with multiple database types (PostgreSQL, MySQL, MongoDB, SQLite)
  - Configurable connection settings and table mapping
  
- `create_note` - Create and manage notes (for documentation)
  - Store important information about database updates
  - Track changes and modifications

## Usage

### Update Database
Use the `update_database` tool with the following parameters:
```json
{
  "filePath": "/path/to/your/file.csv",
  "databaseType": "PostgreSQL",
  "connectionString": "postgresql://user:pass@localhost:5432/db",
  "tableName": "target_table"
}
```

### Supported Database Types
- PostgreSQL
- MySQL
- MongoDB
- SQLite

## Development

Install dependencies:
```bash
npm install
```

Build the server:
```bash
npm run build
```

For development with auto-rebuild:
```bash
npm run watch
```

## Installation

To use with Claude Desktop, add the server config:

On MacOS: `~/Library/Application Support/Claude/claude_desktop_config.json`
On Windows: `%APPDATA%/Claude/claude_desktop_config.json`

```json
{
  "mcpServers": {
    "database-updater": {
      "command": "/path/to/database-updater/build/index.js"
    }
  }
}
```

### Debugging

Since MCP servers communicate over stdio, debugging can be challenging. We recommend using the [MCP Inspector](https://github.com/modelcontextprotocol/inspector):

```bash
npm run inspector
```

The Inspector will provide a URL to access debugging tools in your browser.