CloudBeaver AWS

I have been using CloudBeaver AWS extensively for over two years, since 2022, to query PostgreSQL databases across various environments.

My main use case for CloudBeaver AWS is cross-environment database inspection, data verification, and dynamic SQL testing for PostgreSQL databases. On a day-to-day basis, I use the tool for safely verifying back-end data integrity with direct querying of isolated environments such as dev, stage, and prod, using read-only access to inspect complex back-end processes, including validating generated monthly line items, matching budgets, or checking specific record IDs. I also connect through it using secure tunneling, and I routinely connect to databases hosted in Kubernetes or private networks, using kubectl port-forward or SSH key setups, allowing me to query localhost endpoints without exposing databases publicly. I also use it to test and validate complex SQL, to draft, test, and debug dynamic SQL scripts, and run queries before adding new regular or custom fields into our snapshotter tools and production pipelines.

When I started working at my current company, CloudBeaver AWS was already the tool shared between people. I am not sure who exactly chose it, but it was the tool the company selected to work with, and I have been working with it since then.

The best features CloudBeaver AWS offers for me include the SQL editor and parameterized queries, given the ability to prompt for dynamic variables by entering an ID directly into the query window. This makes troubleshooting specific records fast and error-free. It is also valuable to have multi-environment connection management with easy connection switching and setup, supporting complex security routes such as SSH tunnels and Kubernetes port-forwarding. I also appreciate the visual data grids and type inspection, which grant clear visualization of query results, allowing quick checks on aggregated fields, timestamps, and Boolean verification flags. The support for complex dynamic SQL testing is also excellent. It reliably runs long, multiple union dynamic SQL scripts and snapshotter queries without crashing or lagging.

The SQL editor and parameterized queries in CloudBeaver AWS have drastically reduced our mean time to resolution when verifying data discrepancies. Instead of relying purely on front-end logs or waiting for full pipeline builds, I can directly inspect database tables in dev or stage using read-only access. This empowers developers and technical operators to write, test, and refine complex dynamic SQL queries before pushing field updates to our data tools or snapshotters.

CloudBeaver AWS has positively impacted my organization as it reduces our mean time to resolution when verifying data discrepancies. I can test against a local snapshot of our database rather than fully checking things before they go to the database itself. This gives us opportunities to improve testing and checking the data flows instead of breaking directly into production or customers' data.

While CloudBeaver AWS is robust, there is room for improvement in handling non-standard network drops, such as when kubectl port-forward connection times out in the background, where automatic reconnection could be smoother. Additionally, improved snippet management or offering easier query template sharing across team members would make repetitive troubleshooting scripts even faster to execute.

CloudBeaver AWS is stable.

CloudBeaver AWS scales very efficiently, depending on the deployment strategy.

I did not need to go through customer support for using CloudBeaver AWS. I primarily went through their documentation to set up things, and that has been sufficient. I did not have any issues using the tool until now.

My experience with CloudBeaver AWS's pricing, setup cost, and licensing has been positive as the licensing model offers an exceptional cost-to-value ratio. By leveraging the open-source community edition hosted in our cloud infrastructure or AWS instances, teams get enterprise-grade database management and SQL capabilities at minimal operational costs. I only pay for the underlying compute resources required to host the instance.

I did not need to go through customer support for using CloudBeaver AWS. I primarily went through their documentation to set up things, and that has been sufficient. I did not have any issues using the tool until now.

It is difficult to measure the return on investment with CloudBeaver AWS, but I think it is a good investment to have this tool, as it is used across my company to manage data on our databases and is a useful tool.

I think it is worthwhile to choose CloudBeaver AWS. It is an essential reliable database management tool for cross-environment data verification. CloudBeaver AWS is a powerful SQL editor for debugging PostgreSQL environments safely and efficiently. My overall rating for this product is 10.

Database connectivity is the main use case of CloudBeaver AWS, and I am typically utilizing all kinds of connectors, plugins, database schema, and table formation, all integrated into CloudBeaver. I am using it on the cloud very specifically with all AWS connections so that whatever I need to store on external sources such as S3 buckets or any other Athena queries, I am utilizing CloudBeaver.

The costing is very low and the production quality is also very high. If I want to deploy anything on CloudBeaver AWS, it is very impactful and effective. I can generate any triggers, events, or any kind of dynamic events if I want to do it with the databases, making it very useful. On cloud services, it is very good.

I have utilized CloudBeaver AWS's advanced SQL editor for my query generations and solutions.

For CloudBeaver AWS deployment, it is a plug-and-play kind of simple solution, as I have worked on DBeaver on my local system and it is almost similar to how AWS Marketplace is providing CloudBeaver. The same functionalities are in both, just on the cloud itself.

Regarding the role-based access control of CloudBeaver AWS in securing my data management tasks, everything is very smooth. I consider it has multiple role accesses, and its privacy and identity management are working fine, with access controls perfectly managing different users and their accesses.

In terms of drawbacks, CloudBeaver AWS's cloud instances are slower than what local solutions provide. I consider it very slow compared to my local DBeaver. Additionally, the interface does not look that effective. Debugging is painful; many times I need to understand what needs to be handled, how it needs to be managed, and how the triggers impact the events generated. Knowing what kind of queries need to be triggered when, and how the logs are impacting, all these things are very tedious. Debugging is not smooth or effective compared to what other databases provide.

Regarding the effectiveness of CloudBeaver AWS's data visualization tools, I look at how effective the ER diagrams and schemas are created, the quality of the data import and export that I generate, and what various external factors or formats are available. I focus on how much it supports different types of structured and unstructured data. However, it does not facilitate JSONified kind of structured data, so whenever this comes into the picture, I need to convert it to a different format of files and then it can generate good clarity on the visualization paths. That is the only point I would highlight; other than this, everything is good.

I have been using CloudBeaver AWS for approximately three and a half years.

Regarding technical support of CloudBeaver AWS, they are active on emails but not on other platforms.

Overall, the licensing cost of CloudBeaver AWS is acceptable to me. Bigger instances have higher charges, but it depends on how many users are utilizing the databases and what I am using in the database. I do not have any issues with the subscription plans of CloudBeaver; it is acceptable for me and my organization.

For database management with CloudBeaver AWS, I can utilize it for any kind of power queries or text queries I want to generate or any of the search queries I am looking out for. It is a kind of PowerShell terminal that works directly on my cloud-based database solution and I can get my results very effectively. I can generate all SQL queries nicely with the drivers installed directly into it. No external installation process is needed, and everything is documented and perfectly managed.

I have collaborated with CloudBeaver AWS along with my Athena and all the SageMaker instances I am utilizing. All these have been connected with my Slack channel and Microsoft Teams channel. Multiple integrations and plugins have been integrated, allowing my database connectivity to be directly solved out within my team members to generate any kind of fetching queries, selection queries, or if I need any kind of truncation of the database. My environment looks very fruitful when I look for an ideal solution for teams or organizations. The infrastructure of my database is continuously improving, enabling me to manage SQL and NoSQL altogether. It gives me great clarity on how my database support needs to be maintained and how the development of my SQL editor needs to be highlighted. It also provides basic highlighter options, syntax highlighting options, and auto-suggestions options. I can directly have a query-based editor, which can be utilized to collaborate with multiple user management and tracking tools, or if I look out for query history generation, that is also very fruitful.

The interactive dashboards of CloudBeaver AWS have contributed to my data analysis needs quite a lot. In comparison to Athena, CloudBeaver AWS is very slower than what my local DBeaver or any other database solution is providing. That is one of the points I consider concerning the latency. I also feel the UI is cluttered. Other than this, if I work on any ML algorithms or frameworks, it works perfectly. It provides a better solution to highlight data qualities, giving me full clarity on strengths and weaknesses regarding the products, especially if I am looking at any specific dataset or database. Overall, I would rate this review eight out of ten.