Schema not found in Aurora DSQL

The issues you're experiencing with JetBrains DataGrip and pgAdmin4 when trying to manage Aurora DSQL are related to some specific behaviors and limitations of Aurora DSQL.

For JetBrains DataGrip: The inability to see the schema in the database, while still being able to create schemas and tables using commands, is likely due to how Aurora DSQL handles system metadata. Some SQL clients, including DataGrip, make extensive calls to system metadata to populate schema information. Aurora DSQL doesn't support all of this information and may return errors. This doesn't affect SQL query functionality, but it can impact schema display in the visual interface.

For pgAdmin4: The error message about the "client_min_messages" configuration parameter not being supported is because Aurora DSQL has certain limitations compared to standard PostgreSQL. It doesn't support all PostgreSQL features or configuration parameters.

Regarding using a visual tool to manage Aurora DSQL:

1. You can continue using DataGrip or pgAdmin4, but be aware of their limitations with Aurora DSQL. You may need to rely more on direct SQL commands for schema management rather than the visual interface.

2. Consider using the AWS Management Console for Aurora DSQL. While it may not offer all the features of a dedicated database management tool, it's designed to work with Aurora DSQL's specific features and limitations.

3. You could also explore other PostgreSQL-compatible database tools, but keep in mind that you may encounter similar issues due to Aurora DSQL's unique characteristics.

4. For critical database management tasks, you might need to rely on command-line tools or direct SQL queries rather than visual interfaces.

Remember that Aurora DSQL is designed for specific use cases and may not support all the features you're accustomed to in standard PostgreSQL environments. It's important to familiarize yourself with its specific behaviors and limitations when choosing and using management tools.
Sources
Considerations for working with Amazon Aurora DSQL - Amazon Aurora DSQL
Unsupported PostgreSQL features in Aurora DSQL - Amazon Aurora DSQL