cipher42-mcp

yevgenypats/cipher42-mcp

3.3

If you are the rightful owner of cipher42-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Unified MCP Server for any Database or Data Warehouse (Via Cipher42) is a versatile server that provides a unified API for various tools to interact with databases and data warehouses.

The Unified MCP Server, currently in beta, is designed to streamline the interaction between various tools and databases or data warehouses by providing a unified API. This server supports tools like Claude, Cursor, and Windsurf, enabling them to access deep context about database schemas and perform a variety of tasks. These tasks range from writing SQL queries in an IDE to understanding and visualizing data. The server requires an API key from Cipher42 and relies on a backend like Cipher42 for normalization and indexing, ensuring fast and efficient data retrieval. Cipher42 supports databases such as PostgreSQL, Snowflake, and BigQuery, making it a versatile choice for organizations using these platforms.

Features

  • Unified API for multiple tools
  • Supports PostgreSQL, Snowflake, and BigQuery
  • Provides deep context to database schemas
  • Facilitates SQL writing and data visualization
  • Requires Cipher42 for backend support

Usages

usage with Claude Desktop

{
    "mcpServers": {
      "cipher42": {
        "command": "npx",
        "args": [
          "-y",
          "@yevgenyp/cipher42-mcp@v0.0.7"
        ],
        "env": {
          "CIPHER42_API_KEY": "YOUR_PERSONAL_API_KEY"
        }
      }
    }
  }

Tools

  1. getDatasources

    The current datasources configured and indexed by Cipher42.ai.

  2. getSchemas

    Get the current schemas in a specific datasource.

  3. getTables

    Get the tables including their schemas.

  4. runQuery

    Execute a query and return the results in JSON format.