Skip to main content

Database Updater MCP Server

by AnuragRai017

Apache 2.0

Overview InspectNew Schema Related Servers Reviews Score

Need Help?View Source Code Report Issue

Integrations

Allows importing data from CSV and Excel files into MongoDB databases
Allows importing data from CSV and Excel files into MySQL databases
Allows importing data from CSV and Excel files into PostgreSQL databases

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.

You must be authenticated.

A

security – no known vulnerabilities

A

license - permissive license

A

quality - confirmed to work

hybrid server

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

Tools

A Claude integration that enables updating various database types (PostgreSQL, MySQL, MongoDB, SQLite) from CSV and Excel files through natural language commands.

Related Resources

Reddit Discussion about this server

Related MCP Servers

MCP Alchemy
runekaagaard
-
security
A
license
-
quality
Connects Claude Desktop directly to databases, allowing it to explore database structures, write SQL queries, analyze datasets, and create reports through an API layer with tools for table exploration and query execution.
Last updated -
182
Python
Mozilla Public License 2.0
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
AI SQL Assistant MCP Server
narinzar
-
security
A
license
-
quality
Handles SQL query execution for a natural language interface to SQLite databases, enabling users to interact with databases using plain English rather than writing SQL manually.
Last updated -
1
Python
MIT License

View all related MCP servers

Appeared in Searches

New MCP Servers

ID: yqdoq32xyf