IaSQL is an open-source SaaS to manage cloud infrastructure using a unmodified PostgreSQL database by maintaining a 2-way connection between the hosted database and your AWS account. The rows in the database tables represent the infrastructure in your cloud account. Our dashboard provisions a PostgreSQL database for you and configures it to manage an AWS account and region. The database is automatically backfilled with all your existing cloud resources. Which tables are loaded into an IaSQL database is configured based on what IaSQL modules are installed in a db. Every IaSQL module represents a cloud service like
aws_elb. Once the desired modules are installed with the
install IaSQL PostgreSQL function, run
UPDATE queries on the database by using the PG connection string displayed when you first set up in the dashboard with your preferred PostgreSQL client. Finally run the
iasql_apply PostgreSQL function to provision infrastructure in your cloud account based on the IaSQL db.
What part of the documentation should I look at?
A high-level overview of how the IaSQL documentation is organized will help you know how to quickly find what you are looking for:
- The tutorials will guide you from 0 to an HTTP server to your AWS account using ECS, ECR, RDS and ELB using IaSQL. Start here if you’re new to IaSQL.
- How-to guides are recipes. They guide you through the steps involved in addressing key problems and use-cases. They are more advanced than the quickstart and assume some knowledge of how IaSQL works.
- Concepts provides useful background and describes at a fairly high level the internals of how IaSQL works.
- Technical reference for built-in APIs. They describe how it works and how to use it but assume some knowledge of how IaSQL works.