database updater MCP Server

Local 2025-09-01 00:41:45 0
databases @AnuragRai017/database-updater-MCP-Server

A Claude integration that enables updating various database types (PostgreSQL, MySQL, MongoDB, SQLite) from CSV and Excel files through natural language commands.

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.

[
  {
    "description": "Create a new note",
    "inputSchema": {
      "properties": {
        "content": {
          "description": "Text content of the note",
          "type": "string"
        },
        "title": {
          "description": "Title of the note",
          "type": "string"
        }
      },
      "required": [
        "title",
        "content"
      ],
      "type": "object"
    },
    "name": "create_note"
  },
  {
    "description": "Update the database from a CSV or Excel file",
    "inputSchema": {
      "properties": {
        "connectionString": {
          "description": "Connection string for the database",
          "type": "string"
        },
        "databaseType": {
          "description": "Type of database (e.g., PostgreSQL, MySQL, MongoDB, SQLite)",
          "type": "string"
        },
        "filePath": {
          "description": "Path to the CSV or Excel file",
          "type": "string"
        },
        "tableName": {
          "description": "Name of the table to update",
          "type": "string"
        }
      },
      "required": [
        "filePath",
        "databaseType",
        "connectionString",
        "tableName"
      ],
      "type": "object"
    },
    "name": "update_database"
  }
]