Retrieves a list of all schemas (databases) available in the specified connection. Each schema includes metadata such as name, description, and whether it’s the default schema. This endpoint is useful for exploring the database structure and discovering available data sources.