I'm looking for a program that's specifically not an SQL server. SQL servers seem to deal with permissions, connectivity, and all that jazz.

I just want a command line program that I can give an SQL command or script file, a database file, and have it alter/query the file according to the commands issued. Nothing more, nothing less.

Here's an example of my use case

$ ls
$ sql-thing --command "SELECT MIN(Balance) FROM Users"

1 Answer 1


Sounds like Sqlite would be just the thing. Sqlite comes as a C library and command-line utility that executes SQL statements against a database file. The software intelligently cootdinates multiple connections to one file, but doesn't use a client-server architecture.

  • Worth pointing out it's available cross-platform. And though being very light-weight, can deal with quite some data. For example, a small Nextcloud instance ;)
    – Izzy
    Commented Sep 30, 2020 at 17:16
  • Didn't know SQLite offers a CLI, thought it was just a library. Thanks! :) Commented Oct 11, 2020 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.