Average Ratings 2 Ratings

Total
ease
features
design
support

Average Ratings 1 Rating

Total
ease
features
design
support

Description

Introducing a versatile and free database management tool designed for developers, database administrators, analysts, and anyone who engages with databases. It offers compatibility with a wide range of popular databases, including MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, among others. Recent updates include a new format configuration editor for the "Copy As" feature, enhanced performance through additional configurations in the filter dialog, and the ability to sort by column with fixed settings for smaller fetch sizes. Users can now benefit from case-insensitive filters, while the plaintext view has been improved by incorporating top and bottom dividers. Furthermore, the data editor has been rectified to address issues arising from column name conflicts with alias names, and the command for duplicating rows has been fixed for cases involving multiple selections. The context menu has been updated to include the edit sub-menu once again, and auto-sizing configurations for columns have been introduced. Additionally, the dictionary viewer has been corrected for use with read-only connections, and new features support current and selected row highlighting, which can be customized according to user preferences. This tool continues to evolve, ensuring that users have the best possible experience while working with their database management tasks.

Description

PawSQL embodies the leading practices of query optimization within the database sector, offering sophisticated SQL rewrite enhancements and advanced index suggestions aimed at addressing sluggish queries. Leveraging the expertise of its professional optimization engine, which boasts a user base of over 10,000 database professionals globally, PawSQL delivers an extensive array of SQL optimization advice along with smart index recommendations. Additionally, it features a well-rounded audit rule framework designed for various database systems, including MySQL, PostgreSQL, openGauss, and Oracle, ensuring that enterprises enjoy a uniform auditing experience across their diverse database landscapes. The rule-oriented SQL evaluation focuses on identifying potential correctness flaws and opportunities for performance enhancement. By providing rich rewrite optimization, it suggests semantically equivalent yet more efficient SQL queries, while the cost-based validation confirms that the proposed solutions from SQL rewrites and index recommendations yield superior performance outcomes. Furthermore, PawSQL’s intelligent index recommendation feature enables users to optimize their query performance effectively.

API Access

Has API No 

API Access

Has API Yes 

Screenshots View All

Screenshots View All

Integrations

MariaDB Yes 
MySQL Yes 
PostgreSQL Yes 
AWS Marketplace Yes 
Amazon Athena Yes 
CrateDB Yes 
DataGrip No 
Devart ODBC Drivers Yes 
Firebird Yes 
Google Cloud BigQuery Yes 
IBM Db2 Yes 
LocalStack Yes 
Microsoft Access Yes 
MongoDB Yes 
Phoenix Yes 
PostgresML Yes 
Presto Yes 
SAP Cloud Platform Yes 
SQLite Yes 
Teradata VantageCloud Yes 

Integrations

MariaDB Yes 
MySQL Yes 
PostgreSQL Yes 
AWS Marketplace No 
Amazon Athena No 
CrateDB No 
DataGrip Yes 
Devart ODBC Drivers No 
Firebird No 
Google Cloud BigQuery No 
IBM Db2 No 
LocalStack No 
Microsoft Access No 
MongoDB No 
Phoenix No 
PostgresML No 
Presto No 
SAP Cloud Platform No 
SQLite No 
Teradata VantageCloud No 

Pricing Details

$11/month
Monthly subscription starts at $11
Annual subscription starts at $110
Free Trial Yes 
Free Version No 

Pricing Details

No price information available.
Free Trial No 
Free Version Yes 

Deployment

Web-Based No 
On-Premises Yes 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars Yes 
Live Training (Online) Yes 
In Person Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

DBeaver Corp.

Founded

2017

Country

United States

Website

dbeaver.io

Vendor Details

Company Name

PawSQL

Founded

2024

Country

China

Website

www.pawsql.com

Product Features

Database

Backup and Recovery Yes 
Creation / Development Yes 
Data Migration Yes 
Data Replication No 
Data Search Yes 
Data Security Yes 
Database Conversion No 
Mobile Access No 
Monitoring Yes 
NOSQL Yes 
Performance Analysis Yes 
Queries Yes 
Relational Interface Yes 
Virtualization No 

Product Features

Database Monitoring

Anomaly Detection No 
Autodiscovery No 
Capacity Planning No 
Dashboard No 
Dependency Tracking No 
Historical Trend Analysis No 
Multitenancy No 
Notifications / Alerts No 
Performance Monitoring No 
Permissions / Access Controls No 
Predictive Analytics No 
Prioritization No 
Query Analysis No 
Resource Optimization No 
Troubleshooting No 

Alternatives

Alternatives

SQL Query Tuner Reviews

SQL Query Tuner

IDERA, an Idera, Inc. company