A favicon of Clickhouse and PostgreSQL with Neurelo Connect

Clickhouse and PostgreSQL with Neurelo Connect

Interact with ClickHouse and PostgreSQL databases through Neurelo Connect.

Installation

Installing for Claude Desktop

Option 1: One-Command Installation

npx mcpbar@latest install neurelo-connect/neurelo-connect-mcp -c claude

This command will automatically install and configure the Clickhouse and PostgreSQL with Neurelo Connect MCP server for your selected client.

Option 2: Manual Configuration

Run the command below to open your configuration file:

npx mcpbar@latest edit -c claude

After opening your configuration file, copy and paste this configuration:

View JSON configuration
{
  "mcpServers": {
    "Clickhouse and PostgreSQL with Neurelo Connect": {
      "command": "npx",
      "args": [
        "@neurelo/connect-mcp",
        "start"
      ],
      "env": {
        "ENGINE_API_KEY": "YOUR_ENGINE_API_KEY",
        "ENGINE_BASE_PATH": "YOUR_ENGINE_BASE_PATH"
      }
    }
  }
}

Neurelo Connect MCP Server

npm version License Build

Model Context Protocol (MCP) is a new, standardized protocol for managing context between large language models (LLMs) and external systems. In this repository, we provide an MCP Server for Neurelo Connect.

This lets you use Claude Desktop, or any MCP Client, to use natural language to accomplish things with your databases, e.g.:

- "Show me the schema for my PostgreSQL database"
- "How many users do I have?"
- "Tell me how my databases are related to each other"

Claude Setup

Manual Setup

  1. Open the Claude Desktop configuration file located at:

    • On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
    • On Windows: %APPDATA%/Claude/claude_desktop_config.json
  2. Add the following:

{
  "mcpServers": {
    "neurelo-connect": {
      "command": "npx",
      "args": ["@neurelo/connect-mcp@latest", "start"],
      "env": {
        "ENGINE_API_KEY": "YOUR_ENGINE_API_KEY",
        "ENGINE_BASE_PATH": "YOUR_ENGINE_BASE_PATH"
      }
    }
  }
}

Requirements

  • Node.js >= v18.0.0
  • Claude Desktop
  • A running Neurelo Connect instance
  • Neurelo Connect API key - you can generate one through the Neurelo Connect console.

Features

Supported Tools

  • system_list_databases - List all the available targets
  • system_get_database_status - Check if all database targets are running
  • system_get_database_schema - Get the schema for a given database target
    • Input:
      • target (string): The name of the target database
  • raw_readonly_query - Execute read-only SQL queries on your database
    • Queries are run with readonly access
    • Input:
      • target (string): The target database name
      • query (string): The SQL query to execute
  • raw_query - Execute read/write SQL queries on your database
    • Queries are allowed to modify data
    • Input:
      • target (string): The target database name
      • query (string): The SQL query to execute
  • Dynamic endpoint tools - Additional tools are automatically generated based on your endpoint metadata

Configuration Options

  • --disable-tools <tools> - Comma-separated list of tool names to disable. For example: --disable-tools raw_query,system_list_databases will disable the raw query and database listing tools. You can also disable any defined queries by including their tool names in this list.

Development

Development with the MCP inspector

The easiest way to get started is to use the MCP inspector to run the server in development mode:

npm run inspect

Development with Claude Desktop

Install dependencies:

npm install

Add the following to your Claude Desktop configuration file:

{
  "mcpServers": {
    "neurelo-connect": {
      "command": "npx",
      "args": ["tsx", "REPOSITORY_ROOT/src/main.ts", "start"],
      "cwd": "REPOSITORY_ROOT",
      "env": {
        "ENGINE_API_KEY": "YOUR_ENGINE_API_KEY",
        "ENGINE_BASE_PATH": "YOUR_ENGINE_BASE_PATH"
      }
    }
  }
}

Then, restart Claude each time you want to test changes.

Contributing

We welcome contributions! Please feel free to submit a Pull Request.

Share:
Details:
  • Stars


    0
  • Forks


    1
  • Last commit


    19 days ago
  • Repository age


    4 months
  • License


    MIT
View Repository

Auto-fetched from GitHub .

MCP servers similar to Clickhouse and PostgreSQL with Neurelo Connect:

 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit


 

 
 
  • Stars


  • Forks


  • Last commit


Clickhouse and PostgreSQL with Neurelo Connect: MCP Server – MCP.Bar