Database Updater MCP Server

🚀 Database Updater MCP Server

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

🚀 Quick Start

This Database Updater MCP Server allows you to update databases using data from CSV and Excel files. It provides useful tools and is easy to set up and use.

✨ 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

Updating the Database

When using the update_database tool, specify 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

Installing Dependencies

npm install

Building the Server

npm run build

Development with Automatic Rebuild

npm run watch

Using on Claude Desktop

To use on Claude Desktop, add the server to the configuration file:

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

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 the debugging tools in a browser.