Skip to main content
Glama
Sign In
enesjakozh

Database Updater MCP Server

by AnuragRai017
Verified
GitHub
JavaScript
Apache 2.0
  • Apple
RedditDiscord
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport 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

local-only server

The server can only run on the client's local machine because it depends on local resources.

Tools

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

  1. Features
    1. Tools
  2. Usage
    1. Update Database
    2. Supported Database Types
  3. Development
    1. Installation
      1. Debugging

    Related Resources

    Appeared in Searches

    ID: yqdoq32xyf