connect_database
Establish a connection pool to a CockroachDB database by specifying host, port, credentials, and SSL settings to enable secure data interactions.
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"
}