database_mcp_server

database_mcp_server

3
databases

The Database MCP Server is a Model Context Protocol server that facilitates interaction with multiple database systems, supporting operations across SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server. It offers advanced schema management, query execution, and transaction support, making it a versatile tool for managing databases in various environments.

Database MCP Server

A Model Context Protocol (MCP) server designed for connecting and interacting with various database systems.

Features

  • Connect to SQLite, PostgreSQL, MySQL/MariaDB, and SQL Server databases
  • Common tools for database operations
  • Specialized tools for database-specific features
  • Schema management: create, alter, drop tables and indexes
  • Execute raw SQL queries or use structured query tools
  • Transaction management: begin, commit, rollback transactions

Installation

Prerequisites

  • Python 3.8 or higher
  • Required Python packages installed with pip

Configuration

  • Configure using environment variables, a configuration file, or runtime details

Usage

Run as an MCP Server for Claude or as a standalone web server for any LLM. Offers a variety of database management and query execution tools through HTTP endpoints when used with other LLMs.