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