# Rsql

> Use this skill when the user wants to query databases or data files using SQL from the command line.

- Skill: `javimosch/rsql` (Agent Skill)
- Install (CLI): `npx skillmds@latest add javimosch/rsql`
- Raw SKILL.md: https://api.skillmd.com/api/skills/javimosch/rsql/raw
- Safety review: PASS (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: javimosch (https://skillmd.com/u/javimosch)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/javimosch/rsql

---


# rsql Plugin

Command line SQL interface supporting 30+ databases and data files.

## Commands

### Query
- `rsql query run` — Execute a SQL query against a database
- `rsql file query` — Query a data file (CSV, JSON, Parquet, etc.)

## Usage Examples
- "Query a PostgreSQL database"
- "Run SQL on a CSV file"
- "Query JSON data with SQL"
- "Execute SQL against SQLite"

## Installation

```bash
cargo install rsql_cli
```

## Examples

```bash
# Query PostgreSQL
rsql postgresql://user:pass@localhost/db -e "SELECT * FROM users"

# Query a CSV file
rsql data.csv -e "SELECT name, COUNT(*) FROM data GROUP BY name"

# Query JSON file
rsql data.json -e "SELECT * FROM json_data WHERE value > 100"

# Query SQLite
rsql sqlite:./mydb.sqlite "SELECT * FROM table"

# Interactive mode
rsql postgresql://localhost/mydb
```

## Key Features
- 30+ database drivers (PostgreSQL, MySQL, SQLite, etc.)
- Query data files (CSV, JSON, Parquet, Arrow, etc.)
- Interactive and batch modes
- Output formats: table, CSV, JSON, markdown
- SQL dialects and extensions