AnuragRai017_database-updater-MCP-Server

AnuragRai017_database-updater-MCP-Server

0
databases

The database-updater MCP Server is designed to efficiently update various types of databases using data from CSV or Excel files. It offers tools for database updates and note creation, making it suitable for managing database modifications and documentation.

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:

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

npm install

Build the server:

npm run build

For development with auto-rebuild:

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

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

npm run inspector

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