TKCat End-to-End: From ClickHouse Setup to MCP Server Configuration29 days ago
Introduction | Setting up ClickHouse | Copy-paste setup script | Parameters used in this guide | Step 1: Clone the repository and navigate to docker-init | Step 2: Update Dockerfile | Step 3: Create modified launch script | Step 4: Run the initialization | Preparing MDBs | HPO from ReDaMoR | ClinVar from TKCat | ChEMBL from TKCat | Summary | Pushing MDBs to ClickHouse | Connecting to chTKCat | Preparing the database in ClickHouse | Verifying the push | Querying MDBs | Connecting as a regular user | Exploring available MDBs from R | Example queries | Querying HPO | Querying ClinVar | Querying ChEMBL | Cross-MDB queries | Setting up MCP Server | Local Server (stdio transport) | Requirements | Environment variables | Creating a dedicated user for MCP | Starting the server | Remote Server (HTTP transport) | Architecture | Running the server | Testing the Server using curl | systemd service | nginx configuration | Security considerations | Usage Examples with AI Assistants | Configuring MCP Clients | Claude Code | Local server configuration | Project configuration | Remote server configuration (HTTP transport) | Claude Desktop | Remote server configuration | Posit Assistant | Query examples | Available tools | Example questions | References