💡 Check Out IaSQL: AWS Infrastructure as Data in PostgreSQL
I recently came across IaSQL, an interesting tool that connects your AWS account with a PostgreSQL database.
I've implemented something similar before but between Salesforce and Amazon Connect: you would change a record in Salesforce and the corresponding configuration would change in Amazon Connect. Done via AppFlow, EventBridge, SQS, Lambda and DynamoDB.
But IaSQL seems to go a lot deeper!
Here’s how it works:
🔄 Two-Way Connection: IaSQL maintains a two-way connection between your AWS account and a PostgreSQL database, with rows representing your cloud infrastructure.
🌐 Automatic Import: It automatically imports existing infrastructure, backfilling the database with your cloud resources without the need to redefine or reconcile them.
📚 No New API: IaSQL uses an unmodified PostgreSQL database, allowing you to use any migration system, ORM, or database connector.
📊 Definitive Cloud State: IaSQL's module system lets you specify which parts of your cloud infrastructure you wish to control as tables in PostgreSQL.
For more details, check out the tool here: IaSQL.com
#CloudInfrastructure #SQL #AWS #OpenSource
