Database Info Schema

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.