connect_database

Establish a connection to a CockroachDB database and create a connection pool by specifying host, port, database name, credentials, and SSL settings for secure access.

Instructions

Connect to a CockroachDB database and create a connection pool.

Args: host (str): CockroachDB host. port (int): CockroachDB port (default: 26257). database (str): Database name (default: "defaultdb"). username (str): Username (default: "root"). password (str): Password. sslmode (str): SSL mode (default: disable - Possible values: allow, prefer, require, verify-ca, verify-full). sslcert (str): Path to user certificate file. sslkey (str): Path to user key file. sslrootcert (str): Path to CA certificate file.

Returns: A success message or an error message.

Input Schema

Name	Required	Description	Default
`database`	Yes
`host`	Yes
`password`	Yes
`port`	Yes
`sslcert`	Yes
`sslkey`	Yes
`sslmode`	Yes
`sslrootcert`	Yes
`username`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "database": {
      "title": "Database",
      "type": "string"
    },
    "host": {
      "title": "Host",
      "type": "string"
    },
    "password": {
      "title": "Password",
      "type": "string"
    },
    "port": {
      "title": "Port",
      "type": "integer"
    },
    "sslcert": {
      "title": "Sslcert",
      "type": "string"
    },
    "sslkey": {
      "title": "Sslkey",
      "type": "string"
    },
    "sslmode": {
      "title": "Sslmode",
      "type": "string"
    },
    "sslrootcert": {
      "title": "Sslrootcert",
      "type": "string"
    },
    "username": {
      "title": "Username",
      "type": "string"
    }
  },
  "required": [
    "host",
    "database",
    "port",
    "username",
    "password",
    "sslmode",
    "sslcert",
    "sslkey",
    "sslrootcert"
  ],
  "title": "connect_databaseArguments",
  "type": "object"
}

CockroachDB MCP Server