Database
The Database Analyzer provides a comprehensive overview of database environments, including RDS, DynamoDB, Aurora, and Redshift. It delivers insights for optimizing database performance, ensuring security, and maintaining compliance.
Required Blueprints: Database
Sightlines
| Sightline | Description |
|---|---|
| Databases | High-level overview of all databases — usage, capacity, and structural trends |
| Tables | Table-level metrics — usage, underutilized resources, and trends |
| Views | View-level metrics — performance, dependencies, and query efficiency |
| Users | Database user activity — access control and ownership |
Explorer Node Types
Use these node types in Explorer or KAI to query resources surfaced by this analyzer:
database.sql.Database, database.sql.Table, database.sql.Schema, database.sql.View, database.sql.MaterializedView, database.sql.User, database.sql.Role, database.sql.Column
Related Analyzers
- AWS RDS — AWS-specific RDS cluster security and compliance
- Azure Database — Azure SQL, Cosmos DB, and Redis analysis
- GCP Database — Cloud SQL, Spanner, and BigQuery analysis
Insight Feed Alerts
Count of Nested Views
Identifies databases with excessive nested views, which can degrade query performance and increase maintenance complexity.
Count of Empty Tables
Highlights databases containing empty tables, indicating possible design inefficiencies or unused resources.