Steven Miller: Announcing Tembo CLI: Infrastructure as code for the Postgres ecosystem

Postgres isn’t just a database; it’s a whole ecosystem of extensions and tools for all kinds of tasks. At Tembo Cloud, we’ve made it easy to deploy the Postgres ecosystem of extensions and apps combined to create solutions, which we call “Stacks”. However, users often ask us, what about local development? That’s why we created the Tembo CLI. It’s designed to give you the power to set up Postgres Stacks on your own machine or in CI, mirroring how things will run on Tembo Cloud. This way, you can experiment, develop, and test with confidence, knowing your local setup reflects the cloud environment. Why Tembo CLI? Tembo CLI is the easiest way to try out Postgres extensions, stacks, and apps - whether or not you’re on Tembo Cloud. Tembo CLI also helps you deploy the same Tembo configuration across development, staging, and production environments. This means when you test locally, your workload behaves the same way when deployed to the cloud. Key Features of the Tembo CLI Seamless Deployment Across Environments: Deploy your database locally for development or across any cloud environment (dev, staging, prod) using the same configuration Support for Stacks, Extensions, and Apps: Tailor your Postgres deployments with Tembo Stacks and further customize your setup by specifying additional extensions and apps Simple Configuration: Specify the database(s) for your application in your tembo.toml, then deploy locally or to your cloud environment(s) with the same configuration file What’s it like to use the Tembo CLI? When you’re ready to dive in, please refer to the Tembo CLI Getting Started guide. Using the Tembo CLI is easy. Just define your database(s) in a tembo.toml file. [minimal] environment = "prod" instance_name = "minimal" The above tembo.toml file includes one database. For additional information on how your tembo.toml file can be configured, please see “Configure Tembo CLI” in the Tembo docs. You can also configure a Stack, like this: [my[...]