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

Related MCP server: SQL MCP Server for Claude Desktop

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.

One-click Deploy

A

security – no known vulnerabilities

A

license - permissive license

A

quality - confirmed to work

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Reddit Discussion

Related Servers

Database Updater MCP Server