Labsco
rhabraken logo

Talk with Your Database

★ 1

from rhabraken

Interact with PostgreSQL, MySQL, MariaDB, and SQLite databases using SQLAlchemy.

🔥🔥🔥✓ VerifiedFreeAdvanced setup
#automation#database#devops#git#maps

Talk with Your Database Using MCP

Talk with Your Database Using MCP

This guide explains how to set up and run your MCP server to interact with your PostgreSQL database using Claude Desktop. It should also work with MySQL, MariaDB, SQLite as it uses sqlalchemy under the hood. This project is build on top of https://github.com/runekaagaard/mcp-alchemy

Note: This guide assumes you have a basic understanding of Docker, environment variables, and CLI usage.

3. Launch the PostgreSQL Database with Dummy Data

  1. Run Docker Compose
    Ensure Docker Compose is installed and run: 
    docker-compose up -d
    • This command will launch a PostgreSQL database on localhost:5432 and populate it with dummy data.

5. Configure and Launch the MCP Server

  1. Create/Update the MCP Server Configuration
    Save the following JSON configuration in your MCP server config file (adjust paths if necessary):

    {
  "mcpServers": {
    "my_database": {
      "command": "uv",
      "args": [
        "--directory",
        "/directory/where/this/app/is/located/app/",
        "run",
        "server.py"
      ],
      "env": {
        "DB_URL": "postgresql://postgres:password@localhost:5432/mydatabase"
      }
    }
  }
}
    • Tip: If uv is installed in a non-standard location, update the "command" value to reflect the full path to the executable.

  2. Launch the MCP Server
    With the configuration in place, the MCP server will automatically start each time Claude Desktop is launched.

Summary

  1. Set Up Environment Variables: Copy .env.example to .env.
  2. Install and Run Claude Desktop: Download from Claude Desktop.
  3. Launch PostgreSQL with Docker Compose: Run docker-compose up to start the database with dummy data.
  4. Install uv: Run the provided installation command if necessary.
  5. Configure MCP Server: Update the config file and ensure paths and environment variables are correct.
  6. Launch and Enjoy: Start Claude Desktop to begin interacting with your database via MCP.

If you encounter any issues or need further assistance, please refer to the relevant documentation or contact your support team.

Happy coding!