Database Bulk Update

🚀 Database Update MCP Server

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

🚀 Quick Start

This is a Model Context Protocol (MCP) server designed to update databases using data from CSV and Excel files. It provides useful tools for database operations and documentation management.

✨ Features

Tools

• update_database - Update the database using 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.
  • Record changes and modifications.

💻 Usage Examples

Basic Usage

Update the Database

Use the update_database tool with the following parameters:

{
  "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

📦 Installation

To use on Claude Desktop, add the server configuration:

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

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

🔧 Technical Details

Development

Install dependencies:

npm install

Build the server:

npm run build

Develop with automatic rebuild:

npm run watch

Debugging

Since MCP servers communicate via stdio, debugging can be challenging. We recommend using MCP Inspector:

npm run inspector

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