akili connection

Manage external data connections. Connections define how the platform connects to external data sources and sinks such as PostgreSQL, MySQL, S3, and other systems. Each connection stores the connector type and configuration needed to access the external system.

Commands

akili connection create

Create a new connection.

Flags:

Flag	Short	Default	Description
--name			Connection name (required)
--connector-type			Connector type, e.g., postgres, mysql, s3 (required)
--config			Connection configuration as a JSON string (required)

Examples:

# Create a PostgreSQL connection
akili connection create \
  --name warehouse-pg \
  --connector-type postgres \
  --config '{"host":"db.example.com","port":5432,"database":"warehouse","user":"reader"}'

# Create an S3 connection
akili connection create \
  --name data-lake \
  --connector-type s3 \
  --config '{"bucket":"my-data-lake","region":"eu-central-1","prefix":"raw/"}'

---

akili connection list

List all connections for the current tenant.

Examples:

# List all connections
akili connection list

# As JSON
akili connection list --json

---

akili connection get <id>

Show detailed information about a specific connection.

Arguments:

Argument	Type	Required	Description
id	string	yes	Connection ID

Examples:

# Get connection details
akili connection get conn-abc-123

# As JSON
akili connection get conn-abc-123 --json

---

akili connection update <id>

Update an existing connection. Only provided fields are updated.

Arguments:

Argument	Type	Required	Description
id	string	yes	Connection ID

Flags:

Flag	Short	Default	Description
--name			New connection name
--config			New configuration as a JSON string

Examples:

# Update connection name
akili connection update conn-abc-123 --name production-pg

# Update connection config
akili connection update conn-abc-123 \
  --config '{"host":"new-db.example.com","port":5432,"database":"warehouse","user":"reader"}'

---

akili connection delete <id>

Delete a connection. Requires the --confirm flag.

Arguments:

Argument	Type	Required	Description
id	string	yes	Connection ID

Flags:

Flag	Short	Default	Description
--confirm		false	Confirm the deletion (required)

Examples:

# Delete a connection
akili connection delete conn-abc-123 --confirm

---

akili connection test <id>

Test a connection by attempting to connect to the external system. Reports success/failure and latency.

Arguments:

Argument	Type	Required	Description
id	string	yes	Connection ID

Examples:

# Test a connection
akili connection test conn-abc-123
# Connection test passed: Connected successfully
# Latency: 45ms

---

akili connection discover <name>

Discover available resources (tables, schemas, buckets, etc.) in a connection.

Arguments:

Argument	Type	Required	Description
name	string	yes	Connection name

Examples:

# Discover resources
akili connection discover warehouse-pg

# As JSON
akili connection discover warehouse-pg --json

---

akili connection schema <name> <resource>

Get the schema (columns, types, nullability) for a specific discovered resource.

Arguments:

Argument	Type	Required	Description
name	string	yes	Connection name
resource	string	yes	Resource name (e.g., public.orders)

Examples:

# Get schema for a table
akili connection schema warehouse-pg public.orders

# As JSON
akili connection schema warehouse-pg public.orders --json