steampipe-sqlite
steampipe-sqlite copied to clipboard
Steampipe SQLite is a zero-ETL engine for SQLite. Virtual tables translate queries into live API calls for cloud services and APIs. Hundreds of plugins with thousands of documented examples.
Steampipe SQLite
A family of SQLite extensions, each derived from a Steampipe plugin, that fetch data from cloud services and APIs.
Getting Started
You can use an installer that enables you to choose a plugin and download the SQLite extension for that plugin.
Examples
Select EC2 instances
select * from aws_ec2_instance;
Filter to running instances
select * from aws_ec2_instance
where instance_state='running';
Select a subset of columns
select arn, instance_state from aws_ec2_instance
where instance_state='running';
Limit results
select arn, instance_state from aws_ec2_instance
where instance_state='running'
limit 10;
Developing
To build an extension, use the provided Makefile
. For example, to build the AWS extension, run the following command. The built extension lands in your current directory.
make build plugin=aws
Open Source & Contributing
This repository is published under the Apache 2.0 license. Please see our code of conduct. We look forward to collaborating with you!
Steampipe is a product produced exclusively by Turbot HQ, Inc. It is distributed under our commercial terms. Others are allowed to make their own distribution of the software, but cannot use any of the Turbot trademarks, cloud services, etc. You can learn more in our Open Source FAQ.