https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image2_pawsqllogo216.png
PawSQL - SQL Optimization, Index Recommendation & Performance Monitoring
بواسطة 北京图灵睿数科技有限公司
Just a moment, logging you in...
Automated SQL tuning platform: query rewrite, index advisor, auditing & performance monitoring.
PawSQL is an enterprise-grade database performance optimization platform covering the full SQL lifecycle, from development and testing through operations. It centers on two modules: Optimizer, built for developers, delivers intelligent query rewriting, index recommendations, and performance validation to catch inefficient SQL early; Patroller, built for DBAs and ops teams, continuously monitors live database instances, automatically capturing slow queries and flagging redundant indexes and potential performance or security issues. Together, they provide end-to-end SQL quality management from coding to production.
PawSQL Optimizer
PawSQL Optimizer is the on-demand, developer-facing engine at the core of the platform. It's built around three tightly integrated capabilities:
- Intelligent Query Rewriting — Analyzes a submitted SQL statement's syntax tree and automatically generates semantically equivalent, higher-performing rewrites (e.g., converting inefficient subqueries into optimized JOINs, simplifying redundant predicates, restructuring GROUP BY/aggregation logic).
- Cost-Based Index Advisor — Recommends the optimal set of indexes for a given query workload by comparing execution plans before and after candidate indexes are applied, rather than relying on generic heuristics.
- Performance Validation — Every rewrite or index suggestion is verified against the actual execution plan and cost estimates, so recommendations come with quantified before/after performance data instead of just a suggestion.
It's designed to plug directly into the developer's workflow — through the web console, JetBrains/VS Code plugins, or API/MCP integration — so optimization happens before a query ever reaches production. It works on individual, developer-submitted SQL statements, on-demand.
PawSQL Performance Patroller
PawSQL Patroller is the operations-facing, always-on counterpart, aimed at DBAs monitoring live database instances rather than individual developers writing queries. Its core functions:
- Automated Slow Query Capture — Periodically and automatically pulls slow queries generated by a connected database instance, without requiring anyone to manually submit SQL.
- Automatic Optimization Suggestions — Runs captured slow queries through the same rewrite and index-recommendation engine as Optimizer, surfacing fixes without manual intervention.
- Redundant Index Analysis — Scans existing indexes across the database to identify unused or duplicate ones that are wasting storage/write overhead.
- Database Object Patrol — Periodically scans schemas and database objects (not just queries) to flag potential performance, security, and maintainability issues.
- Slow Query Trend Dashboard — Visualizes slow-query trends over time at the instance level, so DBAs can spot degrading patterns rather than reacting to one-off incidents.
Typical Use Cases
- SQL optimization during development
- SQL quality auditing and code review
- CI/CD SQL validation
- Slow query diagnosis
- Production workload monitoring
- Database migration validation
- Database governance and compliance
لمحة سريعة
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/trailer_3000679869622229535_trailer.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/trailer_3065322117794722064_trailer.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image5_inputQuery.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image3_optimizeTask.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image4_optimizationResult.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image6_pptquery3.png
https://catalogartifact.azureedge.net/publicartifacts/pawsql.pawsql-app-a80215d1-07ba-4e8e-9ffd-0230874b891f/image7_pptobjects3.png