Database Analyzer MCP Server

🚀 Database Analyzer MCP Server

A powerful database analysis tool that offers an MCP (Model Context Protocol) server interface for internal inspection and analysis of PostgreSQL databases. This tool allows you to explore database schemas, relationships, and execute secure queries through a standardized interface.

🚀 Quick Start

Prerequisites

• Python 3.x
• PostgreSQL database
• Required Python packages:
  • mcp (Model Context Protocol)
  • psycopg2 (PostgreSQL adapter)
  • python-dotenv (Environment variable management)

Installation

1. Clone the repository:

git clone <repository-url>
cd MCP-server-demo

2. Install the required packages:

pip install -r requirements.txt

3. Create a .env file in the project root directory with your database credentials:

POSTGRES_HOST=localhost
POSTGRES_PORT=5432
POSTGRES_DB=your_database_name
POSTGRES_USER=your_username
POSTGRES_PASSWORD=your_password

Usage

1. Start the MCP server:

python server.py

2. The server provides the following tools:

✨ Features

Database Schema Analysis

• List all tables in a specified schema.
• Get detailed schema information for a specific table.
• View column definitions, data types, and constraints.

Secure Query Execution

• Execute secure SELECT queries with parameterized inputs.
• Built - in security measures to prevent unauthorized modifications.

🔒 Security Features

• Only allow SELECT queries for security reasons.
• Parameterize queries to prevent SQL injection.
• Use environment - variable - based configuration for sensitive data.
• Automatically clean up connections and manage resources.

⚠️ Error Handling

The server includes comprehensive error handling, including:

• Database connection issues.
• Invalid queries.
• Schema access problems.
• Resource cleanup.