Skip to main content
Glama

Database Updater MCP Server

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.

Install Server
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.

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 MCP Servers

    • -
      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
    • -
      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
      • Linux
      • Apple
    • -
      security
      F
      license
      -
      quality
      Provides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.
      Last updated -
      • Apple
    • -
      security
      A
      license
      -
      quality
      Provides Claude with direct access to databases including SQLite, SQL Server, PostgreSQL, and MySQL, enabling execution of SQL queries and table management through natural language.
      Last updated -
      542
      1
      TypeScript
      MIT License
      • Apple
      • Linux

    View all related MCP servers

    MCP directory API

    We provide all the information about MCP servers via our MCP API.

    curl -X GET 'https://glama.ai/api/mcp/v1/servers/AnuragRai017/database-updater-MCP-Server'

    If you have feedback or need assistance with the MCP directory API, please join our Discord server