Skip to main content

​
What is Queryly?

Queryly is your lightweight, cross-platform database companion. It’s a CLI tool built for developers who need quick access to their databases without the overhead of heavyweight GUI tools like SQL Server Management Studio or pgAdmin. Built with .NET 8 and C#, Queryly delivers a fast, beautiful terminal experience powered by Spectre.Console.

​
Key Features

Multiple Databases

Full support for SQLite, PostgreSQL, MySQL, and SQL Server

Connection Management

Save, test, and organize database connections with ease

Schema Exploration

Browse tables, view column structures, and explore indexes

Data Browsing

View and navigate table data with a beautiful terminal UI

Query Execution

Run custom SQL queries with an interactive query mode

Data Export

Export tables to CSV or JSON formats

Cross-Platform

Works seamlessly on Windows, macOS, and Linux

Lightweight

Fast startup with minimal dependencies

​
Why Use Queryly?

Lightweight and Fast
No more waiting for heavyweight GUI tools to start. Queryly launches instantly and performs operations quickly. Terminal-Focused
Perfect for developers who live in the terminal. Integrates seamlessly with your existing workflow. Cross-Platform
Built with .NET 8, Queryly runs natively on Windows, macOS, and Linux without any platform-specific quirks. Developer-Friendly
Intuitive commands, beautiful terminal UI with Spectre.Console, and helpful error messages make database management a breeze. Open Source
Free to use, modify, and contribute to. Built by developers, for developers.

​
Supported Databases

SQLite

Fully supported with all features

SQL Server

Fully supported including schema exploration

PostgreSQL

Fully supported with all features

MySQL

Fully supported with all features

​
Technology Stack

Queryly is built with modern .NET technologies:
  • Language: C# 12 / .NET 8
  • Database Access: ADO.NET, Dapper
  • Terminal UI: Spectre.Console
  • Configuration: System.Text.Json
  • Testing: xUnit, Moq, FluentAssertions

​
Architecture

Queryly follows a clean, layered architecture: 
┌─────────────────────────────────────┐
│         CLI Layer                   │
│    (Commands, UI, Program.cs)       │
└──────────────┬──────────────────────┘
               │
┌──────────────▼──────────────────────┐
│         Core Layer                  │
│  (Models, Interfaces, Business      │
│   Logic, Connection Management)     │
└──────────────┬──────────────────────┘
               │
┌──────────────▼──────────────────────┐
│       Providers Layer               │
│  (Database-specific implementations)│
│   SQLite, SQL Server, PostgreSQL    │
└─────────────────────────────────────┘
This separation ensures clean code, testability, and easy addition of new database providers.

​
Get Started

Ready to dive in? Follow the quickstart guide to add your first database connection and start exploring your data.

Quick Start

Get up and running with Queryly in under 5 minutes

Build docs developers (and LLMs) love

Get started for freeTalk to us