ExecuteAutomation Database
A Model Context Protocol server that enables LLMs like Claude to interact with SQLite and SQL Server databases, allowing for schema inspection and SQL query execution.
What is ExecuteAutomation Database?
ExecuteAutomation Database is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to model context protocol server that enables llms like claude to interact with sqlite and sql server databases, allowing for schema inspection and sql query execution.
A Model Context Protocol server that enables LLMs like Claude to interact with SQLite and SQL Server databases, allowing for schema inspection and SQL query execution.
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- A Model Context Protocol server that enables LLMs like Claud
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx executeautomation-database-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use ExecuteAutomation Database
The ExecuteAutomation Database MCP Server enables AI models such as Claude to interact directly with SQLite and SQL Server databases through the Model Context Protocol. It exposes eight tools covering the full database workflow — from listing tables and describing schemas to executing SELECT queries, writing data, creating tables, and exporting results as CSV or JSON. Developers and analysts use it to give AI clients safe, structured access to local development databases or production SQL Server instances for schema exploration, data analysis, and query generation.
Prerequisites
- Node.js 18+ and npm installed
- A SQLite database file (for SQLite mode) OR access credentials to a SQL Server instance (for SQL Server mode)
- An MCP-compatible AI client such as Claude Desktop or Claude Code
- For SQL Server: network access to the SQL Server host and appropriate database permissions
Install the database server package
Install the @executeautomation/database-server package globally via npm.
npm install -g @executeautomation/database-serverConfigure for SQLite
For SQLite databases, add the server to your MCP client configuration and pass the path to the .db file as the first argument.
{
"mcpServers": {
"ea-database": {
"command": "npx",
"args": ["-y", "@executeautomation/database-server", "/absolute/path/to/database.db"]
}
}
}Configure for SQL Server
For SQL Server databases, use the --sqlserver flag along with --server and --database flags. Add --user and --password for SQL authentication, or omit them to use Windows integrated authentication.
{
"mcpServers": {
"ea-database": {
"command": "npx",
"args": [
"-y", "@executeautomation/database-server",
"--sqlserver",
"--server", "your-sql-server-hostname",
"--database", "your-database-name",
"--user", "sa",
"--password", "your-password"
]
}
}
}Restart your MCP client
Restart Claude Desktop or your AI client so it picks up the new server configuration. The database server starts on demand when the client connects.
Explore and query your database
Ask your AI client to list tables, describe a schema, or run a query. The server exposes list_tables, describe_table, read_query, write_query, create_table, alter_table, drop_table, and export_query tools.
ExecuteAutomation Database Examples
Client configuration — SQLite (Claude Desktop)
Connect Claude Desktop to a local SQLite database file.
{
"mcpServers": {
"ea-database": {
"command": "npx",
"args": ["-y", "@executeautomation/database-server", "/Users/you/projects/app/dev.db"]
}
}
}Prompts to try
Example prompts that use the database tools for exploration and analysis.
- "List all tables in the database and describe their schemas"
- "Show me the top 10 rows from the users table ordered by created_at descending"
- "Write a SQL query to find all orders placed in the last 30 days and their total value"
- "Create a new table called audit_log with columns id, user_id, action, and timestamp"
- "Export the results of SELECT * FROM products WHERE stock < 10 as a CSV file"
- "Describe the schema of the orders table and suggest any missing indexes"Troubleshooting ExecuteAutomation Database
SQLite error: 'SQLITE_CANTOPEN: Unable to open database file'
The path to the SQLite file must be an absolute path, not relative. Verify the file exists at the exact path you specified (use 'ls /path/to/database.db' to confirm). If the file does not exist, SQLite will try to create a new empty database — make sure you have write permission in that directory.
SQL Server connection failure: 'Failed to connect to SQL Server'
Verify that SQL Server is running and accessible from your machine. Check that the server name, port (default 1433), and database name are correct. If using SQL authentication, ensure the user has CONNECT permission on the database. For Windows authentication (no --user/--password flags), the process must run under a Windows domain account with SQL Server access.
write_query or create_table returns a permission error
The database user configured in the connection must have INSERT/UPDATE/DELETE/CREATE TABLE permissions. For read-only analysis use cases, create a dedicated read-only SQL user and use it in your config. For write access, grant the necessary privileges or use a database owner account in a development environment.
Frequently Asked Questions about ExecuteAutomation Database
What is ExecuteAutomation Database?
ExecuteAutomation Database is a Model Context Protocol (MCP) server that model context protocol server that enables llms like claude to interact with sqlite and sql server databases, allowing for schema inspection and sql query execution. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install ExecuteAutomation Database?
Follow the installation instructions on the ExecuteAutomation Database GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with ExecuteAutomation Database?
ExecuteAutomation Database works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is ExecuteAutomation Database free to use?
Yes, ExecuteAutomation Database is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
ExecuteAutomation Database Alternatives — Similar Databases Servers
Looking for alternatives to ExecuteAutomation Database? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up ExecuteAutomation Database in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use ExecuteAutomation Database?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.