ExecuteAutomation Database Server

A Model Context Protocol server that provides access to SQLite and SQL Server databases. This server enables LLMs like Claude to inspect database schemas and execute SQL queries.

Supported Databases

SQLite - Local file-based database
Microsoft SQL Server - Enterprise relational database

Components

Tools

The server offers nine core tools:

Query Tools

read_query
- Execute SELECT queries to read data from the database
- Input:
  - query (string): The SELECT SQL query to execute
- Returns: Query results as array of objects
write_query
- Execute INSERT, UPDATE, or DELETE queries
- Input:
  - query (string): The SQL modification query
- Returns: { affected_rows: number }

Schema Management Tools

create_table
- Create new tables in the database
- Input:
  - query (string): CREATE TABLE SQL statement
- Returns: Confirmation of table creation
alter_table
- Modify existing table schema (add columns, rename tables, etc.)
- Input:
  - query (string): ALTER TABLE SQL statement
- Returns: Confirmation of table alteration
drop_table
- Remove a table from the database with safety confirmation
- Input:
  - table_name (string): Name of the table to drop
  - confirm (boolean): Safety confirmation flag (must be true to actually drop)
- Returns: Confirmation message or safety warning

Schema Information Tools

list_tables
- Get a list of all tables in the database
- No input required
- Returns: Array of table names
describe_table
- View schema information for a specific table
- Input:
  - table_name (string): Name of table to describe
- Returns: Array of column definitions with names and types

Data Export Tools

export_query
- Export query results to various formats
- Input:
  - query (string): The SELECT SQL query to execute
  - format (string): Output format - either "csv" or "json"
- Returns: Query results formatted as CSV or JSON

Insights

append_insight
- Add a business insight to the memo
- Input:
  - insight (string): Business insight discovered from data analysis
- Returns: Confirmation message

Resources

The server provides schema information for each table in the database:

Table Schemas (sqlite:///<path>/<table>/schema or mssql://server/table/schema)
- JSON schema information for each table
- Includes column names and data types
- Automatically discovered from database metadata

Usage with Claude Desktop

To use this server with the Claude Desktop app, add the following configuration to the "mcpServers" section of your claude_desktop_config.json:

SQLite Database

{
  "mcpServers": {
    "database": {
      "command": "node",
      "args": [
        "/path/to/database-server/dist/src/index.js", 
        "/path/to/database.db"
      ]
    }
  }
}

SQL Server Database

{
  "mcpServers": {
    "database": {
      "command": "node",
      "args": [
        "/path/to/database-server/dist/src/index.js", 
        "mssql://username:password@server:port/database"
      ]
    }
  }
}

You can explicitly specify the database type as the second argument:

{
  "mcpServers": {
    "database": {
      "command": "node",
      "args": [
        "/path/to/database-server/dist/src/index.js", 
        "Server=myserver;Database=mydatabase;User Id=myuser;Password=mypassword;", 
        "mssql"
      ]
    }
  }
}

The Claude Desktop config file is typically located at:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/Claude/claude_desktop_config.json

Replace all paths with your actual file paths.

Building and Development

Quick Build

Use the included build script to install dependencies and build the project:

chmod +x build.sh
./build.sh

Manual Build Steps

# Install dependencies
npm install

# Build the TypeScript
npm run build

Docker Build

docker build -t executeautomation/database-server -f Dockerfile . 

Troubleshooting

If you encounter connection issues:

Make sure the database connection string is correct
For SQL Server, ensure the server is accessible from your machine
Check that you have the correct permissions to access the database
Verify that the compiled JavaScript file exists at the specified path
Check the Claude Desktop logs for detailed error messages
Restart Claude Desktop after making configuration changes

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License.

About ExecuteAutomation

This server is maintained by ExecuteAutomation. Visit executeautomation.com for more tools and resources.