queryli

queryli is a multi-database CLI for managing connection profiles and running SQL through a persistent local daemon.

It supports PostgreSQL, MySQL, SQLite, and Oracle.

Features

• Manage multiple database connection profiles.
• Keep one active database connection alive through a background daemon.
• Run ad hoc SQL queries or execute .sql files.
• Print query results as table, JSON, or CSV.
• Install a SKILL.md helper for local AI coding agents.

Install

With npm:

npm install -g queryli

From the repository root:

go install .

Make sure your Go binary directory is on PATH. On Windows this is commonly:

%USERPROFILE%\go\bin

Verify:

queryli --help

AI Agent Skill

Install a queryli skill for supported local coding agents:

queryli install-skill

By default this installs user-level skills for:

• Codex: ~/.agents/skills/queryli/SKILL.md
• Claude Code: ~/.claude/skills/queryli/SKILL.md
• Cursor: ~/.cursor/skills/queryli/SKILL.md
• Gemini CLI: ~/.gemini/skills/queryli/SKILL.md
• Windsurf: ~/.codeium/windsurf/skills/queryli/SKILL.md

Install for one agent:

queryli install-skill --agent claude
queryli install-skill --agent cursor

Install into the current project:

queryli install-skill --agent all --scope project

Use a custom skills directory:

queryli install-skill --dir ~/.some-agent/skills

Quick Start

Create a PostgreSQL profile:

queryli profile add --name local-pg --type postgres \
  --host localhost --port 5432 --user postgres --db postgres --sslmode disable

Create a SQLite profile:

queryli profile add --name local-sqlite --type sqlite --path ./dev.db

Set the active profile:

queryli profile use local-pg

Connect:

QUERYLI_PASSWORD=your-password queryli connect

Run a query:

queryli query "SELECT 1" --format json

Execute a SQL file:

queryli exec ./script.sql

Check status:

queryli status
queryli ping

Disconnect:

queryli disconnect

Commands

queryli profile add
queryli profile list
queryli profile remove
queryli profile use
queryli connect [profile]
queryli disconnect
queryli status
queryli ping
queryli query <sql>
queryli exec <file.sql>
queryli install-skill

Configuration

Profiles are stored in:

~/.queryli/config.yaml

Runtime daemon files are stored in the same directory:

~/.queryli/daemon.pid
~/.queryli/daemon.sock
~/.queryli/daemon.meta
~/.queryli/daemon.log

Passwords are not stored by profile add. Pass credentials at connect time:

QUERYLI_PASSWORD=your-password queryli connect local-pg

or:

queryli connect local-pg --password your-password

Output Formats

Use --format or -f:

queryli query "SELECT * FROM users LIMIT 5" --format table
queryli query "SELECT * FROM users LIMIT 5" --format json
queryli query "SELECT * FROM users LIMIT 5" --format csv

Development

Run checks:

go test ./...

Build locally:

go build .

Build an amd64 binary compatible with older CPUs:

GOAMD64=v1 go build .

Build the npm release binaries:

npm run build:npm

The npm release build pins GOAMD64=v1 for amd64 targets so the binaries do not require AVX-capable CPUs.

Preview the npm package:

npm pack --dry-run

Publish to npm:

npm login
npm publish