Database Info Schema
This module provides a diagnostic tool to explore your database's schema and metadata. It allows you to view all tables and their fields, examine indexes, and track storage usage for the entire database and individual tables and indexes. This helps with auditing, onboarding new developers, and performance tuning.
Overview
This is a Schema & Metadata Explorer that works as an administrative and diagnostic tool designed to give developers and database administrators a comprehensive, real-time look into the database's architecture and physical footprint. It serves as a centralized tool for structural introspection and storage monitoring.
Key Features
- Schema Inventory: Retrieves and lists all table names existing within the connected database or specific schemas.
- Field-Level Introspection: Drills down into individual tables to display all fields (columns), detailing their specific data types, character maximum lengths, nullability, and key constraints.
- Index Mapping: Catalogs all indexes associated with each table (e.g., primary, unique, non-clustered), providing visibility into how data retrieval is currently optimized.
- Granular Storage Metrics: Calculates and displays precise data consumption metrics, including:
- Total Database Size: The aggregate disk space currently utilized by the entire database.
- Table Sizes: The specific storage footprint of the data within each individual table.
- Index Sizes: The disk space consumed specifically by the indexes on each table, allowing administrators to weigh query performance benefits against storage costs.
Primary Value
This module streamlines database auditing, accelerates onboarding for new developers by providing immediate structural context, and aids in performance tuning and capacity planning by clearly highlighting where storage is being heavily utilized.