Visualize and explore your Apache AGE graph data.
Kotte connects to PostgreSQL with the Apache AGE extension and turns your graph databases into interactive visualizations. Write Cypher queries, browse metadata, and explore relationships through an intuitive interface—no configuration required beyond your connection details.
- Cypher query editor — Write and run Cypher with syntax highlighting, parameter support, and query history. Use
Ctrl+Enterto execute; long-running queries can be cancelled. - Parameterized queries — Pass JSON parameters for dynamic, reusable queries.
- Results as graph or table — Toggle between an interactive graph view and a sortable, paginated table. Export to CSV or JSON.
- Interactive visualization — Pan, zoom, and navigate your graph. Click nodes to inspect properties; double-click to pin or unpin nodes.
- Expand neighborhoods — Right-click a node and expand its neighborhood to discover connected nodes and edges on the fly.
- Multiple layouts — Force-directed (default), hierarchical, radial, grid, and random. Switch layouts to find the best view for your data.
- Visual styling — Nodes colored by label, edges by relationship type; size reflects connectivity.
- Metadata sidebar — Browse all graphs, node labels, edge types, and approximate counts. Click a label to see sample Cypher for that type.
- Saved connections — Store database credentials with AES-256-GCM encryption. Reuse connections across sessions.
- Session-based auth — Secure HttpOnly cookies, CSRF protection, and configurable rate limiting.
- Encrypted credentials — Saved connections are encrypted at rest with AES-256-GCM.
- Read-only mode — Optional
QUERY_SAFE_MODEto block mutating queries for production or shared environments.
make compose-up-devOpen http://localhost:5173 and connect with host age, database postgres, user postgres, password postgres.
For production deploys there's a separate hardened compose file — see deployment/README.md.
Or run manually without Docker: docs/QUICKSTART.md.
- Connect — Enter your PostgreSQL + AGE connection details
- Select a graph — Pick an AGE graph from the sidebar
- Query — Write Cypher in the editor; results appear as graph or table
- Explore — Toggle views, inspect metadata, export, and browse history
- Quick Start — Installation and setup
- User Guide — Using Kotte
- Configuration — Environment variables and options
- Architecture — Technical design
- Contributing — Development guide
- Migrations — Alembic chain for the target AGE database (
make migrate-up) - Roadmap — Prioritised engineering follow-ups; see REVIEW.md for the holistic gap analysis that fed it
- Changelog — Notable changes per release
Kotte is released under the Apache License 2.0. See NOTICE for attribution.