# Cloud Tools You Probably Haven't Heard Of

Keeping an eye on your cloud resources becomes increasingly difficult as their number grows. However, the tools below offer effective solutions for monitoring resources and controlling costs.

## Komiser

[Komiser](https://www.komiser.io/) is an open-source platform loved by cloud experts and developers. Connect your cloud accounts to get detailed insights into your cloud infrastructure.

It provides a nice dashboard to see your **cloud assets inventory**, understand their **resource dependencies**, and uncover **idle, underutilized, and untagged resources**. Komiser aims to bring **transparency** to cloud management. I see it as a useful tool for creating an inventory of your cloud resources. It can be connected to AWS, GCP, Azure, Digital Ocean, and more. It is interesting to see what resources are abstracted from when using a library like AWS CDK or AWS SAM.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915841206/d7cc820a-8c59-4937-ac0b-0ef4a41b5a34.gif align="left")

## Steampipe

[Steampipe](https://steampipe.io/) is a tool for querying cloud APIs and other data sources using SQL in a zero-ETL manner.

Some key capabilities include:

* Dynamically query APIs, code repositories, logs, and other data sources using SQL for unified access.
    
* Combining data from different sources creates new insights through relationships and attributes across entities.
    
* It operates without needing to set up traditional databases through its "Zero-ETL" approach of querying data directly at the source.
    
* Providing metadata about available data tables and fields to help with the discovery and understanding of cloud resources and attributes.
    

I think Steampipe's [dashboards](https://hub.powerpipe.io/) (Mods) make Steampipe more powerful. They offer a variety of them, such as [AWS Well-Architected](https://hub.powerpipe.io/mods/turbot/aws_well_architected), [AWS Compliance](https://hub.powerpipe.io/mods/turbot/aws_compliance), and many more.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915836092/49440315-8775-4586-b2cd-7a29e712b96e.gif align="left")

If you look for an inventory, you can check [how to build your dashboard](https://powerpipe.io/docs/build/writing-dashboards).

## StackQL

Like [Steampipe](#steampipe)'s revolutionary approach, [StackQL](https://stackql.io/) harnesses the power of SQL to query your resources seamlessly. Moreover, it empowers you to utilize SQL syntax for querying and creating resources.

```sql
INSERT INTO aws.s3.buckets (bucket, region)  
SELECT 'stackql-demo',  
'eu-central-1'
```

It is versatile and usable. Even though it is written in Go, they provide a Python package, which means you can use it with [Jupyter Notebooks](https://stackql.io/blog/cloud-security-and-inventory-analysis-with-stackql-and-jupyter). I also like their guide on using it with [Superset](https://stackql.io/blog/stackql-dashboards-with-superset). In comparison to Steampipe, you can query all AWS services, whereas Steampipe is missing some. However, Steampipe offers autocompletion, which StackQL not have.

I used this [instruction](https://stackql.io/docs/cookbooks/aws/aws-global-inventory) to create the inventory of my AWS account.

## ChatWithCloud

Thanks to a generative AI model, [ChatWithCloud](https://chatwithcloud.ai/) allows users to interact with and manage their AWS cloud infrastructure using natural language commands in their terminal. Some key capabilities mentioned include:

* Performing cost analysis to find out spending and optimize costs
    
* Conducting security analysis by reviewing IAM policies and resources
    
* Troubleshooting infrastructure issues to understand problems and how to fix them
    
* Having the ability to fix infrastructure issues directly through commands
    
* There is no need for AWS knowledge or API keys to use most basic functions
    

So, in summary, ChatWithCloud provides a natural language interface for viewing, analyzing, and troubleshooting AWS resources with the help of an AI assistant. You must buy a license and use your OpenAI key or subscribe to it.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915849266/d923a995-36a1-4f33-85d3-7e59f5d875e2.gif align="left")

## Conclusion

All these tools provide a comprehensive overview of your AWS resources. *Komiser* also displays costs, while *ChatWithCloud* provides answers by entering prompts. *Steampipe* and *StackQL* use SQL to interact with the cloud. Additionally, you can connect these to dashboards to visualize them, similar to any data analytics process.

## Bonus: Create Inventory with AWS Console

Instructions are from [here](https://bobbyhadz.com/blog/aws-list-all-resources).

The tools above offer dynamic monitoring of your AWS resources. But what if you need inventory just once or less frequently? The following steps allow you to create a CSV of all the resources within your account:

* Use the `Resource Group & Tag Editor`.
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915149957/27a1875a-36df-43b9-a542-a80298674603.png align="left")
    
* Choose the regions from which you want to fetch. The more regions you select, the longer it will take.
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915155266/a82d2c5f-1e25-4cec-a976-3bfb1dd69cb7.png align="left")
    
* Then download them.
    
    ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1711915160943/43ed433a-1f75-4124-8540-30ec0235a430.png align="left")