SOQL Analyzer Dashboard

View project on View on GitHub

Optimize Your Apex Code Like a Pro

Analyze Apex classes, identify SOQL queries, get AI-powered insights, and ensure governor limit compliance with our cutting-edge dashboard.

Getting Started

Follow these simple steps to set up your SOQL Analyzer Dashboard and start optimizing your Apex code today.

1

Prerequisites

Install Node.js (v18+), npm/yarn, and ensure you have Google Cloud Vertex AI access.

2

Clone Repository

Get the latest version of our codebase:

git clone
3

Install Dependencies

Set up all required packages:

npm install
4

Configure Environment

Create your .env file with your GOOGLE_API_KEY for AI functionality.

5

Run Frontend

Start the Next.js development server:

npm run dev
6

Run Backend

Launch the Genkit backend service:

npm run genkit:dev

Key Features

Discover the powerful capabilities that make SOQL Analyzer Dashboard the ultimate tool for Apex developers.

Core Functionality

  • Paste or upload Apex code seamlessly
  • Extract and list all SOQL queries with precise line numbers
  • Real-time code analysis and parsing
  • Comprehensive query detection algorithms

Analysis & Insights

  • SOQL usage meter with governor limits tracking
  • Query-in-loop detection and performance warnings
  • Performance bottleneck identification
  • Code complexity metrics and scoring

AI-Powered Tools

  • LLM-powered query explanation and documentation
  • AI-based refactor suggestions and optimizations
  • Best practice linter powered by Genkit
  • Intelligent code recommendations

Developer Experience

  • Monaco Editor with syntax highlighting
  • Code history sidebar with version tracking
  • Dark/light mode with system preference detection
  • Toast notifications and responsive design

Tech Stack

Built with modern technologies and industry-leading tools for maximum performance and reliability.

Frontend Technologies

  • Next.js + React + TypeScript
  • Tailwind CSS for styling
  • ShadCN UI component library
  • Monaco Editor for code editing
  • Recharts for data visualization

AI & Backend Services

  • Genkit framework integration
  • Google AI / Gemini models
  • Context-aware LLM insights
  • Custom AI flows with Genkit Flow runner
  • Real-time AI processing pipeline

Development Tools

  • ESLint and Prettier for code quality
  • Husky for Git hooks
  • Jest for unit testing
  • Cypress for end-to-end testing
  • GitHub Actions for CI/CD

Cloud & Deployment

  • Vercel for frontend deployment
  • Google Cloud Platform integration
  • Vertex AI for machine learning
  • Edge computing optimization
  • CDN and global distribution