Aion

Aion is a modern, cross-platform SQL client designed for developers and DBAs. It provides a native desktop experience for querying, managing, and exploring multiple database systems simultaneously.

Key Features

Multi-Database Support

Connect to and query multiple database engines from a single application:

• PostgreSQL — Full support including query plans and transaction management
• MySQL — Complete query execution and schema browsing
• SQL Server — Native support via Microsoft.Data.SqlClient
• SQLite — Lightweight local database support
• LiteDB — Embedded NoSQL database support

Tab-Based Query Interface

Work on multiple queries in parallel with a tabbed editor interface. Each tab maintains its own connection context, query state, and results — allowing you to work across databases without losing context.

• Named, saveable query tabs
• Independent connection and database selection per tab
• Query persistence across sessions

Smart Result Grid

A powerful result grid with advanced selection and inspection capabilities:

• Row and column selection — Click, Ctrl+click, and Shift+click for multi-select
• JSON detection and viewer — Automatically detects JSON content in result cells and opens a formatted viewer
• Copy as JSON or CSV — Right-click context menu to copy cells, rows, or selections
• Foreign key viewer — Inspect foreign key relationships directly from results

Query Plan Visualization

Understand how your queries execute with built-in plan visualization:

• Estimated plans — View the query optimizer's plan before execution
• Actual plans — See the real execution plan after running a query
• Supports TEXT, XML, and JSON plan formats depending on database

Inline Editing

Edit table data directly in the result grid, similar to DBeaver's edit mode:

• Right-click a table and select "Edit Data" to enter edit mode
• Modify cell values inline with visual change indicators
• Preview generated SQL (INSERT, UPDATE, DELETE) before applying
• Apply or discard pending changes with a single click

Transaction Management

Full transaction support within query tabs:

• Begin, commit, and rollback transactions
• Visual transaction state indicator
• Execute queries within an active transaction context

Export

Export query results in multiple formats:

• CSV — Standard comma-separated values
• JSON — Structured JSON output
• Excel — Native .xlsx via ClosedXML
• SQL — Export queries as .sql files

SQL Formatting

Built-in SQL beautification to keep your queries readable and consistent.

Connection Health Monitoring

Smart connection health checks that adapt to your usage:

• Automatic polling of recently active connections
• Activity-based intervals — only checks connections used in the last 30 minutes
• Manual refresh for on-demand health verification
• Visual status indicators (Checking, Connected, Disconnected)

Architecture

Aion is built on .NET with Blazor and uses Hermes for cross-platform desktop hosting. It follows a Flux-inspired unidirectional data flow pattern with the Mythetech Framework message bus for decoupled command and event handling.

Getting Started

Visit the Aion GitHub Repository for installation and usage instructions.