Steampipe - SQL For Everything |
Written by Nikos Vaggalis | |||
Monday, 03 March 2025 | |||
Steampipe renders SQL as the main query language The notion behind Steampipe is that SQL has been the data access standard for decades. It levels the playing field, easily integrates with other systems and accelerates delivery. So why not leverage it for things other than the database, like querying APIs and Cloud services? Steampipe does just that; it enables a uniform data access method for querying:
The question is how does it pull this feat off? As such there's a myriad of plugins for any case imaginable, like: OpenAPI steampipe plugin install openapi Query all the endpoints available for an API: select
select Hacker News steampipe plugin install hackernews select
select There's the plugin repository where you'll find plugins for the following categories:
There's 146 plugins in total at the time of writing but the list keeps growing. Installation wise: # MacOS # Linux or Windows (WSL2) Then install a plugin for your favorite service (e.g. AWS, Azure, GCP, GitHub, Kubernetes, Hacker News, etc). What's more, Steampipe latest architecture decouples Steampipe from its batteries-included Postgres database, so you could use plugins with your own database. That effort resulted in three new plugin flavors: for Postgres, for SQLite, and for standalone export. A great tool with a great ecosystem. SQL for the win! More InformationRelated ArticlesYou Can Now Code Websites With SQL
To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.
Comments
or email your comment to: comments@i-programmer.info |
|||
Last Updated ( Monday, 03 March 2025 ) |