Django ORM Inspector

The Django ORM Inspector analyzes a Django project's models to reveal how the ORM translates to SQL and where inefficiencies may arise. It targets backend developers, DB engineers, and performance teams who want early visibility during design, refactoring, or pre-deployment reviews. The tool outputs an inspection report with model-to-SQL mappings, relationship summaries, and sample queries, plus practical recommendations on indexing and fetch strategies. It performs static analysis only, and never executes application code or writes to the database.

It loads the Django project structure, identifies the target model, and collects field types, relationships, and related managers. Using Django's introspection APIs, it constructs representative SELECT patterns and fetch paths, such as select_related and prefetch_related variants. For each path, it generates a sample SQL block and a scaled estimate of rows involved, enabling teams to reason about worst-case and average-case loads without running queries. The output is designed to support design reviews and performance planning.

The tool's value includes early detection of N+1 patterns, guidance on indexing and fetch strategy, and a structured report that fits into documentation or CI dashboards. Advanced users can adjust depth, choose granular vs aggregated samples, and export the report for documentation or CI pipelines. It supports multi-model analysis and cross-app relationships across common Django setups, emphasizing standard ORM behavior rather than vendor-specific features.