← ClaudeAtlas

dbcli-querylisted

Execute SELECT queries on 30+ databases (SQLite, SQL Server, MySQL, PostgreSQL, Oracle, etc.) using DbCli. Returns data in JSON, table, or CSV format. Use when user needs to query databases, read data, or execute SELECT statements.
DrOlu/agent-skills · ★ 0 · API & Backend · score 66
Install: claude install-skill DrOlu/agent-skills
## Command Style (Use PATH) All examples use the plain command name `dbcli` (no directory prefix). Ensure `dbcli` is on PATH instead of hardcoding paths like `.\.claude\skills\dbcli\dbcli.exe`. # DbCli Query Skill Execute SELECT queries on 30+ databases using the DbCli command-line tool. ## Connection Configuration Set environment variables before using dbcli: ```bash # PowerShell $env:DBCLI_CONNECTION = "your-connection-string" $env:DBCLI_DBTYPE = "database-type" # Bash export DBCLI_CONNECTION="your-connection-string" export DBCLI_DBTYPE=database-type ``` Or use config file: ```bash # If appsettings.json is in the current working directory, DbCli auto-loads it dbcli query "..." ``` # DbCli Query Skill Execute SELECT queries on 30+ databases using the DbCli command-line tool. ## When to Use This Skill - User wants to query database tables - User needs to read data from a database - User mentions SELECT, query, search, filter, or find data - User wants to retrieve records from any supported database ## Supported Databases DbCli is built on SqlSugar and supports 30+ databases. Examples: SQLite, SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, ClickHouse, Doris, OceanBase, TDengine, DuckDB, etc. ## Command Syntax **Environment variables or config file required (no `-c` parameter):** ```bash # Set environment variables first: # DBCLI_CONNECTION="connection-string" # DBCLI_DBTYPE=database-type dbcli query "