IaSQL is open-source software to manage cloud infrastructure using an unmodified PostgreSQL database by maintaining a 2-way connection between a database and your AWS account. The rows in the database tables represent the infrastructure in your cloud account. 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, IaSQL will push the changes in your database to the cloud. To run IaSQL locally run:
docker run --pull=always -p 9876:9876 -p 5432:5432 --name iasql iasql/iasql
Now simply open
http://localhost:9876 in your preferred browser to open the IaSQL dashboard.
Read more about managing your AWS account here. There is also a hosted version of IaSQL that provisions everything for you.
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.
- Reference and code samples for IaSQL modules describes how each module works and how to use it but assumes some knowledge of how IaSQL works.