CSV Plugin for Steampipe

Use SQL to query data from CSV files.

Get started
Documentation: Table definitions & examples
Community: Slack Channel
Get involved: Issues

Quick start

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;

Developing

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

Contributing

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:

Project Name	Stars	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.

Steampipe Plugin Csv

CSV Plugin for Steampipe

Quick start

Developing

Contributing