Skip to content

AxonOps — AI-Native Control Plane for Open Source Data Platforms

CQLAI Quickstart

Get started with CQLAI in under 5 minutes.


Terminal window
# Using Homebrew
brew install axonops/tap/cqlai
# Or download directly
curl -L https://github.com/axonops/cqlai/releases/latest/download/cqlai-darwin-arm64 -o cqlai
chmod +x cqlai
sudo mv cqlai /usr/local/bin/
Terminal window
curl -L https://github.com/axonops/cqlai/releases/latest/download/cqlai-linux-amd64 -o cqlai
chmod +x cqlai
sudo mv cqlai /usr/local/bin/
Terminal window
cqlai --version

Terminal window
cqlai
Terminal window
cqlai --host cassandra.example.com
Terminal window
cqlai --host cassandra.example.com --username myuser --password mypassword
Terminal window
cqlai --host cassandra.example.com --ssl

cqlai> USE my_keyspace;
cqlai:my_keyspace> SELECT * FROM users LIMIT 10;
-- List keyspaces
cqlai> DESCRIBE KEYSPACES;
-- Describe a table
cqlai> DESCRIBE TABLE my_keyspace.users;
-- Quick schema view
cqlai> .schema
CommandDescription
.helpShow available commands
.schemaShow current schema
.tablesList tables in current keyspace
.clearClear the screen
.exitExit CQLAI

Generate CQL queries from natural language descriptions.

Terminal window
# OpenAI
export OPENAI_API_KEY=sk-...
# Anthropic Claude
export ANTHROPIC_API_KEY=sk-ant-...
# Local Ollama (no API key needed)
ollama serve
cqlai> .ai show all users who signed up this week
Generated CQL:
SELECT * FROM users
WHERE created_at >= '2024-01-08'
ALLOW FILTERING;
Execute? [Y/n]: y

cqlai> .export users users.csv
cqlai> .export users users.csv --format csv
cqlai> .export users users.parquet --format parquet
cqlai> .export users users.json --format json

Export query results:

cqlai> .export "SELECT * FROM orders WHERE status = 'pending'" pending.csv

Create a configuration file for persistent settings. CQLAI supports JSON format:

// ~/.config/cqlai/config.json (or ~/.cqlai.json or ./cqlai.json)
{
"host": "cassandra.example.com",
"port": 9042,
"username": "myuser",
"ssl": {
"enabled": true
},
"ai": {
"provider": "openai",
"model": "gpt-4"
}
}

See Configuration for all available options.