database-updater MCP Server

What is database-updater MCP Server?

A Model Context Protocol server that allows updating databases from CSV and Excel files. It integrates with multiple database types (PostgreSQL, MySQL, MongoDB, SQLite) and is designed for users who need to import tabular data into database tables via MCP tools.

How to use database-updater MCP Server?

Install dependencies with npm install, then build with npm run build. Configure the server in Claude Desktop’s claude_desktop_config.json (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json; Windows: %APPDATA%/Claude/claude_desktop_config.json) by adding the path to build/index.js. Invoke the update_database tool with parameters: filePath, databaseType, connectionString, and tableName.

Key features of database-updater MCP Server

• update_database tool for importing CSV and Excel files
• Supports PostgreSQL, MySQL, MongoDB, SQLite databases
• create_note tool for documenting database updates
• Configurable connection settings and table mapping
• Written in Node.js; uses stdio transport
• Includes MCP Inspector support for debugging

Use cases of database-updater MCP Server

• Migrating data from spreadsheets into a PostgreSQL database
• Automating monthly Excel report imports into MySQL
• Loading CSV files into SQLite during development
• Tracking changes with notes alongside database updates

FAQ from database-updater MCP Server

What file formats are supported?

CSV, Excel (.xlsx, .xls).

Which database types are compatible?

PostgreSQL, MySQL, MongoDB, SQLite.

How do I configure this server with Claude Desktop?

Add a database-updater entry to the mcpServers object in Claude’s config file, pointing to the built index.js script.

How can I install and build the server?

Run npm install then npm run build. For auto-rebuild during development, use npm run watch.

How do I debug the server?

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