2 posts tagged with "Plugin"

💡 Introduction​

PawSQL for Jetbrains (PawSQL Client) is a powerful Jetbrains plugin that seamlessly integrates PawSQL engine's intelligent SQL optimization capabilities into your development environment. It supports smart index recommendations, query rewriting, and automated performance validation. Working in conjunction with PawSQL Cloud (https://pawsql.com) or enterprise private deployment of the PawSQL optimization platform, it provides developers with one-click SQL performance optimization capabilities.

🎯 One-Click SQL Optimization in IDEA/DataGrip​

Select the SQL text to be optimized, right-click, and choose which workspace to perform SQL optimization

✨ Core Features​

• 🚀 One-Click Optimization - Intelligently analyze and optimize SQL query performance
• 📊 Index Optimization - Smart recommendations for optimal index combinations, comprehensively improving query efficiency
• 🔄 Query Rewriting - Automatically generate equivalent SQL statements with better performance
• 📈 Performance Validation - Precisely quantify optimization effects, providing detailed performance improvement data

🔧 Installation Guide​

Install from Jetbrains Marketplace​

1. Launch Jetbrains IDE tool (such as IDEA/DataGrip)
2. Search for "PawSQL Client" in Plugins and install

Install from Disk​

1. Download this plugin from Jetbrains Marketplace

2. Install it from Disk

⚙️ Initial Configuration​

1. Fill in the following information in the configuration interface:

• PawSQL Server address (e.g., https://pawsql.com)
• Account information
• Password

2. Click save to complete configuration

🌐 About PawSQL​

PawSQL focuses on database performance optimization automation and intelligence, providing solutions covering the entire process of SQL development, testing, and operations. It widely supports various mainstream commercial and open-source databases including KingbaseES, offering developers and enterprises a one-stop innovative SQL optimization solution. It effectively solves database SQL performance and quality issues, improves database system stability, application performance, and infrastructure utilization, saving enterprises significant maintenance costs and time investment.

💡 Introduction​

PawSQL for VSCode is a powerful Jetbrains plugin that seamlessly integrates PawSQL engine's intelligent SQL optimization capabilities into your development environment. It supports smart index recommendations, query rewriting, and automated performance validation. Working in conjunction with PawSQL Cloud (https://pawsql.com) or enterprise private deployment of the PawSQL optimization platform, it provides developers with one-click SQL performance optimization capabilities.

Optimize a SQL Query​

1. Optimize in Default Workspace:

   • Click the "Optimize" button in the SQL statement prompt

2. Optimize in Specific Workspace:

   • Click the "Optimize..." button in the SQL statement prompt
   • Select a workspace from the dropdown menu

Features​

• Index Advise: Recommend optimal indexes based on input SQL syntax, database objects and statistics information
• Query Rewrite: Recommend semantically equivalent, but more efficient SQLs
• Performance Validation: Ensure better performance after SQL rewrite and index recommendation

Supported Databases​

MySQL, PostgreSQL, MariaDB, Oracle, openGauss, KingbaseES, GaussDB, Dameng, RDS for MySQL and etc.

Resources​

• Docs of PawSQL

• PawSQL Optimizer

• PawSQL Performance Patroller

• PawSQL Plan Visualizer

🌐 About PawSQL​

PawSQL is dedicated to automatic and intelligent database performance optimization. The products provided by PawSQL include:

• PawSQL Cloud, an online automated SQL optimization tool that supports SQL auditing, intelligent query rewriting, cost-based index recommendations, suitable for database administrators and data application developers.
• PawSQL Advisor, an IntelliJ plugin that is suitable for data application developers and can be installed via the IDEA/DataGrip marketplace by searching for "PawSQL Advisor" by name.

Contact Us​

Email: service@pawsql.com

Website: https://www.pawsql.com