Kexi

What is Kexi?

Kexi is part of the KDE ecosystem and developed under the Calligra suite, though released independently. It aims to provide desktop database functionality similar to Microsoft Access, allowing users to design tables, forms, queries, and reports visually. Development has been ongoing for years, but with intermittent release cycles, reflecting its niche audience.

It's best suited for desktop users who need lightweight database solutions—like small business operators, educators, or hobbyists—who want structured data without setting up a full server backend. It doesn't require SQL expertise up front, but supports it for advanced use.

Compared to Access, Kexi feels less polished and integrated, with fewer templates and a steeper learning curve for workflows like report generation. It lacks VBA-like scripting but uses Python and JavaScript for logic. It’s functional but not as fluid for users accustomed to Office-style tooling.

Best for: Users needing a desktop database tool on Linux without server setup.

Key features of Kexi

• Visual table and form designer
• Query builder with SQL support
• Report creation tool
• Import from CSV and other databases
• Support for embedded scripts in Python or JavaScript
• Native support for SQLite and PostgreSQL
• Cross-platform: runs on Linux, Windows

Tips for Windows users

Kexi doesn't open .mdb or .accdb files directly. Export Access data to CSV or ODBC first. The interface uses Qt-style dialogs, so expect different keyboard shortcuts and layout. Use the query builder instead of SQL view for easier transition. Reports take more manual setup than in Access.