Skip to main content
If you are new to PawSQL, start with Optimize Your First SQL Query, then use this guide to learn about workspaces, database context, and the complete workflow.

​
Start here

Installation & Access

Sign in to PawSQL Cloud, deploy PawSQL Server, or configure the IDE plugin and MCP.

Workspaces & Context

Build the context SQL analysis needs through DDL or a database connection.
1

Choose how to use PawSQL

Pick PawSQL Cloud, PawSQL Server, the IDE plugin, PawSQL MCP, or the API based on your use case. See Choose How to Use PawSQL.
2

Complete installation or sign in

Connect to the PawSQL service and confirm the account can access the target organization or project.
3

Create a workspace

Specify the database type and version, and import metadata such as tables, columns, and indexes via DDL or a database connection.
4

Complete your first task

Submit a SQL statement and review the findings, rewrite result, index suggestions, and automated performance validation.
5

Enter the team workflow

Continue to configure review tickets, quality gates, performance patrol, permissions, or system administration based on your role.

​
Read by role

​
Core objects

A workspace does not create or modify business databases. It stores the database context needed for SQL analysis; the target database only changes when you explicitly run SQL or index changes.

​
User Guide sections

Installation & Access

Workspaces & Context

SQL Optimization

SQL Review

Batch Optimization & Patrol

Rules & Quality Policy

Developer Tool Integration

CI/CD & Platform Integration

​
Using this guide

Guides typically include prerequisites, steps, result explanations, notes, and related documents. Available features vary by version and license; refer to the product UI, your license, and Supported Databases for the exact scope.

​
Getting help

When you hit an issue, note the PawSQL version, access method, database type and version, workspace, task ID, full error message, and a minimal SQL or DDL that reproduces the problem. Remove passwords, tokens, connection strings, and sensitive business data before submitting.