Project Name | Stars | Downloads | Repos Using This | Packages Using This | Most Recent Commit | Total Releases | Latest Release | Open Issues | License | Language |
---|---|---|---|---|---|---|---|---|---|---|
Q | 9,801 | 3 months ago | 1 | February 27, 2018 | 98 | gpl-3.0 | Python | |||
q - Run SQL directly on delimited files and multi-file sqlite databases | ||||||||||
Textql | 8,830 | 10 months ago | 1 | February 27, 2018 | 37 | mit | Go | |||
Execute SQL against structured text like CSV or TSV | ||||||||||
Datasette | 7,832 | 35 | 130 | a day ago | 120 | May 02, 2022 | 512 | apache-2.0 | Python | |
An open source multi-tool for exploring and publishing data | ||||||||||
Countries States Cities Database | 4,908 | 10 days ago | 41 | odbl-1.0 | PHP | |||||
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities | ||||||||||
Octosql | 4,504 | 2 | 2 days ago | 32 | September 04, 2022 | 39 | mpl-2.0 | Go | ||
OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. | ||||||||||
Dsq | 3,126 | 3 months ago | 1 | March 02, 2022 | 19 | other | Go | |||
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. | ||||||||||
Ethereum Etl | 2,548 | 7 hours ago | 37 | May 24, 2022 | 132 | mit | Python | |||
Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ | ||||||||||
Province City China | 1,874 | 9 | 5 months ago | 4 | March 22, 2022 | 15 | mit | JavaScript | ||
🇨🇳最全最新中国【省、市、区县、乡镇街道】json,csv,sql数据 | ||||||||||
Sqliteviz | 1,715 | 15 days ago | 28 | apache-2.0 | JavaScript | |||||
Instant offline SQL-powered data visualisation in your browser | ||||||||||
Trdsql | 1,495 | 2 | a month ago | 46 | January 19, 2022 | 13 | mit | Go | ||
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats. |
Use SQL to query data from CSV files.
Install the plugin with Steampipe:
steampipe plugin install csv
Configure your config file to include directories with CSV files. If no directory is specified, the current working directory will be used.
Run steampipe:
steampipe query
Run a query for the my_users.csv
file:
select
first_name,
last_name
from
my_users;
Prerequisites:
Clone:
git clone https://github.com/turbot/steampipe-plugin-csv.git
cd steampipe-plugin-csv
Build, which automatically installs the new version to your ~/.steampipe/plugins
directory:
make
Configure the plugin:
cp config/* ~/.steampipe/config
vi ~/.steampipe/config/csv.spc
Try it!
steampipe query
> .inspect csv
Further reading:
Please see the contribution guidelines and our code of conduct. All contributions are subject to the Apache 2.0 open source license.
help wanted
issues: