Home

What is sqly?

The sqly command is a command-line tool for executing SQL queries on CSV/TSV/LTSV/JSON files and Microsoft Excel™. sqly is written in Golang and supports cross-platform usage. Similar tools include harelba/q, dinedal/textql, noborus/trdsql, and mithrandie/csvq.

One of the unique strengths of sqly is that it allows you to interactively build SQL queries using the sqly shell. You can interactively execute SQL with SQL completion and command history. Of course, you can also execute SQL without running the sqly-shell. Since sqly uses SQLite3 to execute SQL, the SQL syntax is equivalent to SQLite3.

Document for users

• Installation
• How to use
• SQLY shell
• SQLY helper command
• Alternative tools

Document for developers

• How to build & test
• Auto-generate files
• Architecture
• Design Overview

Topics

• Why I created sqly
• The origin of the name sqly

Contributing

If you find a bug or have a feature request, please open an issue. If you want to contribute, please open a pull request. We welcome contributions from the community. Documentation updates are also.

The sqly project performs quality checks using GitHub Actions. The following items are checked in GitHub Actions:

• Whether it can be built
• Whether tests pass
• Whether auto-generated files are up-to-date
• Whether test coverage exceeds 83%
• Whether it passes multiple linters (e.g., whether it follows architectural rules, whether it has security measures, etc.)

Contributing is not limited to development. Providing a GitHub Star or becoming my sponsor also greatly boosts my motivation for development.

License

MIT License