Drivers

Choose a driver using the scheme at the start of the connection URL. Every page below describes its URL format, options, examples, and usage notes. Run .drivers to see which drivers are available in your build.

rsql --url 'sqlite://' -- 'SELECT 42;'
rsql --url 'csv://people.csv' -- 'SELECT * FROM people LIMIT 10;'

Quote the URL in your shell, especially when it contains ?, &, or semicolons. In the formats below, angle brackets mark values to replace and square brackets mark optional parts; do not include those brackets literally. Percent-encode reserved characters in credentials, filenames, and option values.

File drivers accept relative and absolute paths. Most structured-file drivers load data into an in-memory SQL context; database drivers connect directly to a database. Transport and compression drivers delegate to a detected format driver. Their pages describe which options are forwarded.

Databases and JDBC

Structured files

Files and remote resources

Compression