数据库更新器 MCP 服务器

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.

Install Server

HTTP connection URL

security – no known vulnerabilities

license - permissive license

quality - confirmed to work

How are these scores calculated?

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

Claude 集成可以通过自然语言命令从 CSV 和 Excel 文件更新各种数据库类型（PostgreSQL、MySQL、MongoDB、SQLite）。

Related Resources

Reddit Discussion about this server

Related MCP Servers

MCP-Python
rhabraken
-
security
F
license
-
quality
A server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.
Last updated -
Python
SQL MCP Server for Claude Desktop
meanands
-
security
F
license
-
quality
A natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.
Last updated -
2
Python
MCPDB - Database Access MCP Server
jantuitman
-
security
F
license
-
quality
Provides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.
Last updated -
MCP Database Server
JuanYin1
-
security
A
license
-
quality
Provides Claude with direct access to databases including SQLite, SQL Server, PostgreSQL, and MySQL, enabling execution of SQL queries and table management through natural language.
Last updated -
470
1
TypeScript
MIT License

View all related MCP servers

Database Updater MCP Server

database-updater MCP Server

Features

Tools

Usage

Update Database

Supported Database Types

Development

Installation

Debugging

Related Resources

Related MCP Servers

MCP-Python

SQL MCP Server for Claude Desktop

MCPDB - Database Access MCP Server

MCP Database Server

Appeared in Searches

MCP directory API