Aqua Help

Database Tools and SQL

With Aqua's support of the database management functionality, you can query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Aqua supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and others. See the full list of supported vendors in Create a data source.

Get started with database tools

These topics are focused on describing features, functionality, the application interface, and might help you to get started quickly.

Glossary

Learn the main concepts.

Create a data source

Start working with your database by creating a connection configuration for it.

Run a query

Connect an SQL file to a data source and run your code.

View results

Connect an SQL file to a data source and run your code.

Work with data

View and edit data in data editor.

Export/Import

Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql.

Diagrams

Generate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements.

Troubleshooting

Connectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you.

Last modified: 11 February 2024