# Feature List

Kangaroo features	v2021	v2022	v2023	v2024	v2025
AI Assistant
Text to SQL
Format/Minify
Schema and Files
Translation
Analyze & diagnose
General
MySQL 5.1 or later
MariaDB 10.0 or later
PostgreSQL 9.5 or later
SQLite 3.0
SQL Server 2008 or later
Connection
Secure connection: SSH/SSL
Clone
Group and Organization
Multip views
Database object support
Database
Schema
Table
View
Index
Trigger
Function/procedure
Data Viewer and Editor
Grid view
Form view
Chart view
Map view
Generate cell value
Update cell value with algorithm
Copy cell value with algorithm
Text, Image viewer/editor
Hex, Web viewer/editor
Raw mode editing
Customize data type colorings
Filter records
SQL/Script Processing
SQL/Script Editor
SQL keyword auto-completion
User schema auto-completion
Visual SQL/Script Builder
SQL/Script Beautifier and Minifier
Find and replace
Open query files in an external editor
Data Modeling
Conceptual, Logical and Physical model
Reverse/forward engineering
Add lines, layers, images, notes, art-texts and shapes
Export database diagrams to PDF and graphic files
Import/Export
Import from file formats: TXT, CSV, XML, JSON
Export to file formats: TXT, CSV, XML, JSON
Export data to Markdown, HTML
Generate design document(Markdown, HTML)
Data Manipulation
Dump/Execute SQL file
Server Security
Manage role
Manage user
Other Useful Features
Database wide search
Dark mode
Shortcut customize
Editor scheme
Split view
Theme support