qry is a command-line interface (CLI) tool designed to provide an interactive query runner for various databases, including PostgreSQL and SQLite. It provides a REPL-like experience for executing SQL queries against connected databases.

• Interactive REPL: Execute SQL queries in real-time.
• Multi-Database Support: Currently supports PostgreSQL and SQLite.
• Easy Configuration: Connect using standard Data Source Names (DSN).

If you have Go toolchain installed you can use go install:

go install github.com/kostya-zero/qry

You can go to releases page and download binary for your OS and architecture.

Run the tool by providing a DSN:

# Provide a SQLite DSN
./qry file:my_database.db

# Provide a PostgreSQL DSN
./qry "postgres://user:password@localhost:5432/dbname"

The driver is automatically detected from the DSN. You can also specify it explicitly or use an environment variable:

# Using DATABASE_URL environment variable
DATABASE_URL="postgres://user:password@localhost:5432/dbname" ./qry

# Specifying driver explicitly
./qry -d postgres "user=myuser password=mypass dbname=mydb"

• -d, --driver: Specify the database driver (postgres or sqlite).
• --list-drivers: List all supported database drivers.

This project is licensed under the terms of the MIT license.