stackql
stackql-middleware
| stackql | stackql-middleware | |
|---|---|---|
| 5 | 1 | |
| 435 | 7 | |
| 36.1% | - | |
| 8.5 | 10.0 | |
| 10 days ago | over 1 year ago | |
| Go | TypeScript | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
stackql
-
Cloud Tools You Probably Haven't Heard Of
Like Steampipe's revolutionary approach, StackQL harnesses the power of SQL to query your resources seamlessly. Moreover, it empowers you to utilize SQL syntax for querying and creating resources.
- Unified analytics and IaC framework for cloud, IdP, and SaaS providers using SQL
- StackQL Studios - Query, provision, secure & operate cloud resources using SQL
-
SQL based OpenAPI client for cloud and SaaS providers
We are working on a new project called StackQL, which makes it easier for developers to query and manipulate data from cloud and SaaS providers using SQL grammar and semantics.
StackQL is an API client built on top of provider OpenAPI specs with future support for GraphQL and gRPC/proto defs.
Some links are here:
https://github.com/stackql/stackql
stackql-middleware
-
Unified analytics and IaC framework for cloud, IdP, and SaaS providers using SQL
Hi HN, we have an open-source project called StackQL which can be used for CSPM, cross-provider UAM/entitlements reporting, inventory analysis, and finops across different public cloud and SaaS providers; see https://github.com/stackql/stackql-provider-registry. In addition, StackQL can be used for IaC (across different cloud providers), including multi-cloud transaction and rollback capability, which we are building out. Can be used standalone (in exec or server mode running a postgres wire protocol server) or using Docker, Python, Jupyter, within GitHub Actions (incl https://github.com/marketplace/actions/stackql-studios-stack... and https://github.com/marketplace/actions/stackql-studios-stack...) and more.
The project can also be used with a private registry (API provider) as an application query interface - like GraphQL - except using SQL statements and transformations (including scalar and aggregate functions, joins, unions, and table-valued functions - see https://github.com/stackql/stackql-middleware and https://github.com/stackql/stackql-playground.
We are looking for contributors!! The core project is written in Golang with tests implemented using the Robot framework and Python. We have about 40 related repos in our org, spanning Python, Jupyter, JavaScript/TypeScript (Deno and NodeJS). Let us know what you think!
What are some alternatives?
steampipe - Zero-ETL, infinite possibilities. Live query APIs, code & more with SQL. No DB required.
squid - 🦑 Provides SQL tagged template strings and schema definition functions.
stackql-playground
database-lab-engine - DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
stackql-provider-registry - Registry for cloud and SaaS providers for StackQL, generated from extensions to the providers OpenAPI3 specification
node-pg-migrate - Node.js database migration management for PostgreSQL
node-starter-kit - Node.js / GraphQL project template pre-configured with TypeScript, PostgreSQL, login flow, transactional emails, unit tests, CI/CD workflow.