database-updater MCP Server

What is database-updater MCP Server?

A Model Context Protocol server for updating databases from CSV and Excel files. It supports PostgreSQL, MySQL, MongoDB, and SQLite, and provides configurable connection settings and table mapping.

How to use database-updater MCP Server?

Install dependencies with npm install, build with npm run build, then configure the server in your Claude Desktop config file. Invoke the update_database tool with a file path, database type, connection string, and target table name.

Key features of database-updater MCP Server

• Supports CSV and Excel (.xlsx, .xls) files
• Compatible with PostgreSQL, MySQL, MongoDB, SQLite
• Configurable connection string and table mapping
• Includes a create_note tool for tracking changes
• Built with TypeScript and runs as a Node.js process

Use cases of database-updater MCP Server

• Import CSV data into a PostgreSQL table
• Update a MySQL database from an Excel spreadsheet
• Load data into a MongoDB collection from a CSV file
• Document database update operations with notes

FAQ from database-updater MCP Server

What database types are supported?

PostgreSQL, MySQL, MongoDB, and SQLite are supported.

What file formats can be imported?

CSV, Excel (.xlsx), and Excel (.xls) formats are supported.

How do I configure the server for Claude Desktop?

Add the server configuration to claude_desktop_config.json with the command pointing to the built index.js file. Example config is provided in the README.

How can I debug the server?

Use the MCP Inspector by running npm run inspector, which provides a URL with debugging tools.

Is there a way to keep notes about updates?

Yes, the create_note tool allows you to store important information and track changes related to database updates.