A repository of provider interface documents supporting stackql (stackql GitHub repo).
StackQL provider interface documents inform the stackql application on how to interact with a given provider (like aws, azure, google, etc), including what methods are available in the provider and how to invoke these using SQL semantics. Provider interface documents are yaml formatted, OpenAPI specifications with extensions.
The documents are versioned per provider in this repository, and built as signed and compressed as packaged artifacts. The packaged artifacts are registered and published to the StackQL Provider Registry Artifact Repository in AWS S3. The provider registry API is a Deno Deploy application that serves the provider interface documents to the stackql application using the REGISTRY LIST and REGISTRY PULL commands.
The following diagram shows the context of the provider registry:
C4Context
System_Ext(github_repo, "stackql-provider-registry", "GitHub Repository")
System_Ext(github_actions, "Build and Deploy", "GitHub Actions")
SystemDb(artifact_repo, "Artifact Repository", "AWS S3")
System(deno_registry, "Provider Registry API", "Deno Deploy")
System(stackql, "StackQL Application", "stackql")
Rel(github_repo, github_actions, "triggers...")
Rel(github_actions, artifact_repo, "registers and pushes to...", "signed tgz package")
Rel(github_actions, deno_registry, "pushes to...", "signed tgz package")
Rel(stackql, deno_registry, "list and pulls registry docs from...", "REGISTRY LIST | REGISTRY PULL")
UpdateLayoutConfig($c4ShapeInRow="3", $c4BoundaryInRow="0")
UpdateRelStyle(github_repo, github_actions, $offsetY="10", $offsetX="-20")
UpdateRelStyle(github_actions, artifact_repo, $offsetY="44", $offsetX="-55")
UpdateRelStyle(github_actions, deno_registry, $offsetY="-18", $offsetX="-130")
UpdateRelStyle(stackql, deno_registry, $offsetY="40", $offsetX="-40")
The public StackQL Provider Registry is distributed via Deno Deploy, using the following endpoints:
| Endpoint | Description |
|---|---|
| registry.stackql.app | Production registry (built from main) |
| registry-dev.stackql.app | Development registry (built from develop) |
Please see .github/CONTRIBUTING.md.
StackQL providers are generated from provider OpenAPI or Swagger specifications (either supplied by the provider or constituted through other scripts - for example, google-discovery-to-openapi or stackql-azure-openapi).
Once you have an OpenAPI specification, you can use the openapisaurus utility project to generate a StackQL provider document.
The provider registry is built and deployed using GitHub Actions. Provider documents are validated and tested in workflow steps and then packaged and stored in the artifact repository. The most recent packaged versions are published to the registry API (a Deno Deploy application), where they are available from the stackql application using REGISTRY LIST or REGISTRY PULL. See docs/build-and-deployment.md for more information.
Use the following steps to test a provider using the dev registry:
export DEV_REG="{ \"url\": \"https://registry-dev.stackql.app/providers\" }"
./stackql --registry="${DEV_REG}" shell