CmdID

CmdID / Commands

usql

Universal CLI interface for SQL databases. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

Connect to a specific database

usql sqlserver://username:password@host:port/database_nameIdentify

Execute commands from a file

usql --file path/to/query.sqlIdentify

Execute a specific SQL command

usql --command "sql_command"Identify

[Interactive] Run an SQL command in the usql prompt

commandIdentify

[Interactive] Display the database schema

\d

[Interactive] Export query results to a specific file

\g path/to/file_with_results

[Interactive] Import data from a CSV file into a specific table

\copy path/to/data.csv table_name