About this software
PawSQL Advisor is an IntelliJ IDE plugin that integrates PawSQL's SQL optimizer into JetBrains IDEs. It performs SQL auditing, query rewriting, and cost-aware index recommendations, and can validate performance changes. The plugin supports major databases including MySQL, PostgreSQL and Oracle and installs from the JetBrains Marketplace. Configuration requires a PawSQL server or workspace, with options for cloud use or private deployment according to PawSQL documentation.
Purchase
JetBrains 3rd Party Paw SQL Advisor
In Stock
Delivery: 1 working day
Loading...
€141.45
Free and without obligation
Do you need more information or looking for another license?
Benefits
- Index recommendations: Suggests index combinations based on query structure and table statistics.
- Query rewriting: Generates semantically equivalent queries with improved execution plans.
- Performance validation: Compares execution metrics to quantify optimization impact.
- IDE integration: Runs inside JetBrains IDEs for local developer workflows.
- Multiple database support: Supports MySQL, PostgreSQL, Oracle and other SQL dialects.
Available languages
- English
- Chinese (Simplified)
Support information
- Documentation: Online docs cover installation, configuration and usage for the JetBrains plugin.
- FAQ: An online FAQ addresses common connection, configuration and behavior questions.
- Marketplace page: The JetBrains Marketplace listing provides install and compatibility details for IDE versions.
- Private deployment guidance: Docs and blog posts describe PawSQL Engine and Docker deployment options for private installs.
- Community links: PawSQL lists community channels such as Slack and social accounts on its site.
Frequently asked questions
Which JetBrains IDEs does the plugin support?
The plugin supports IntelliJ IDEA, DataGrip, PyCharm, Android Studio, AppCode, DataSpell, GoLand, PhpStorm and WebStorm as listed in PawSQL documentation.
What optimization features does the plugin provide?
PawSQL Advisor provides SQL auditing, query rewriting, cost-aware index recommendations, and performance validation within the IDE.
Which databases are supported by PawSQL Advisor?
PawSQL documents support for MySQL, PostgreSQL and Oracle plus additional databases such as openGauss, MariaDB and KingbaseES.
How is the plugin installed and configured?
Install the plugin from the JetBrains Marketplace and configure a PawSQL server address and account in the plugin project settings.
Can PawSQL be deployed privately for enterprise use?
Yes; PawSQL documentation and product pages describe options for private deployment, including a self-hosted engine and Docker-based installs.