Kassie

Appearance

KassieDatabase Explorer for Cassandra & ScyllaDB

Modern terminal and web interface for exploring your Cassandra and ScyllaDB clusters

Get Started
View on GitHub
Kassie
🖥️

Dual Interface

Choose between a fast terminal UI (TUI) or a modern web interface. Both are first-class citizens with full feature parity.

📦

Single Binary

No dependencies, no runtime requirements. One binary contains the server, TUI client, and web UI. Just download and run.

⚡

Fast & Lightweight

Built in Go for maximum performance. TUI launches in <100ms, web UI in <500ms. Minimal resource usage (<50MB RAM).

🔐

Secure Authentication

JWT-based authentication with access and refresh tokens. Credentials never exposed to clients. Session management built-in.

⌨️

Keyboard-Driven

Vim-like navigation in TUI. Full keyboard shortcuts in web UI. Designed for terminal enthusiasts and power users.

🎨

Beautiful Design

Polished TUI with multiple themes. Modern web UI with dark mode. Syntax highlighting and JSON inspection built-in.

🔍

Smart Filtering

Apply WHERE clauses with syntax validation. Filter by partition keys, clustering keys, and more. Query history included.

📄

Pagination Made Easy

Seamless pagination through large datasets. Cursor-based navigation. No memory issues with million-row tables.

🔄

Real-time Schema

Browse keyspaces, tables, and columns instantly. View partition keys, clustering keys, and indexes. Schema caching for performance.

Quick Start ​

Get up and running in 30 seconds:

bash
brew tap KashifKhn/kassie
brew install kassie
kassie tui
bash
go install github.com/KashifKhn/kassie@latest
kassie tui
bash
curl -sSL https://kassie.dev/install.sh | bash
kassie tui
bash
docker run -it ghcr.io/kashifkhn/kassie tui

Why Kassie? ​

The Problem ​

Working with Cassandra and ScyllaDB traditionally means:

  • Typing repetitive DESCRIBE commands in cqlsh
  • Manually paginating through results
  • No visual hierarchy or navigation
  • Risk of accidental data mutations
  • Poor exploration experience

The Solution ​

Kassie provides a modern, safe way to explore your data:

  • Visual Navigation: Tree-view sidebar with all keyspaces and tables
  • Read-Safety First: Optimized for browsing and observing data
  • Multiple Interfaces: Terminal UI for SSH sessions, Web UI for teams
  • Single Binary: No installation hassles, works everywhere

Comparison ​

FeatureKassiecqlshOther GUIs
InstallationSingle binaryPython + depsComplex setup
InterfaceTUI + WebCLI onlyGUI only
NavigationVisual treeManual queriesVaries
PerformanceFast (<100ms)SlowVaries
Remote AccessBuilt-in serverSSH onlyRequires setup
Keyboard-Driven✓Partial✗
FilteringSmart validationManual CQLVaries
AuthenticationJWT tokensPassword onlyVaries

Use Cases ​

Development ​

Quickly inspect data during development. View schema changes. Test queries with instant feedback.

DevOps ​

SSH into production servers and use TUI to investigate issues. No GUI required. Fast and efficient.

Team Collaboration ​

Run Kassie server, share the web UI link. Everyone can explore the same cluster with proper authentication.

Data Exploration ​

Browse large tables with pagination. Filter by keys. Inspect complex data types (maps, sets, UDTs) in JSON format.

What's Next? ​

Released under the MIT License.

Copyright © 2024-present KashifKhn