mcp-database-server

Overview

This MCP server enables Claude to interact with multiple database systems through a unified interface. It provides tools for executing SQL queries, managing database schema, exporting data, and storing business insights. The server supports both direct usage via NPM package and local development configurations.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• read_query

  Execute SELECT queries to read data

  Try:Show me all customers from the databaseTry:List all products with prices greater than $50
• write_query

  Execute INSERT, UPDATE, or DELETE queries

  Try:Add a new customer to the customers tableTry:Update product prices by 10%
• create_table

  Create new tables in the database

  Try:Create a new orders table with customer_id and product_id columnsTry:Design a table for storing product reviews
• alter_table

  Modify existing table schema

  Try:Add a new column to the users tableTry:Change the data type of the price column
• drop_table

  Remove a table from the database

  Try:Delete the temporary_orders tableTry:Remove the unused backup table
• list_tables

  Get a list of all tables

  Try:Show all tables in the databaseTry:List all available tables
• describe_table

  View schema information for a table

  Try:Show the structure of the customers tableTry:Describe the orders table columns
• export_query

  Export query results as CSV/JSON

  Try:Export customer data to CSVTry:Save product information as JSON
• append_insight

  Add a business insight to memo

  Try:Note that sales increased by 20% this quarterTry:Record that customer satisfaction is at 95%
• list_insights

  List all business insights

  Try:Show me all business insightsTry:List previously recorded insights

Comparable tools

Installation

npm install -g @executeautomation/database-server

{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "@executeautomation/database-server",
        "/path/to/your/database.db"
      ]
    }
  }
}

FAQ

Which databases are supported?

SQLite, SQL Server, PostgreSQL, and MySQL databases are supported.

How do I authenticate with AWS RDS?

Use the --mysql --aws-iam-auth flags with appropriate AWS credentials configured in your environment.

Compare mcp-database-server with