SQL Workspace - AI2sql

Worksheet

Free

Context Tables:

Query result

Script output

DBMS output

Explain Plan

SQL history

Run a query to see results

No script output available

DBMS output is empty

Run EXPLAIN PLAN to see query execution details

Library

Community

Recently Viewed

🔍 Data Quality

Find Duplicate Records

Identify duplicate rows based on specific columns. Edit {table_name} and {column1, column2} to match your schema.

Click to use

📊 Analytics

Create Pivot Table

Transform rows into columns for cross-tabulation analysis. Perfect for summarizing data by categories.

Click to use

⚡ Performance

Index Usage Analysis

Analyze index usage statistics to identify unused or missing indexes that affect query performance.

Click to use

📈 Window Functions

Running Totals & Cumulative Sum

Calculate running totals, cumulative sums, and moving averages using window functions.

Click to use

📅 Time Series

Find Gaps in Dates

Identify missing dates or gaps in sequential date ranges for time series analysis.

Click to use

🏆 Ranking

Top N Records per Group

Get the top N records within each group using ROW_NUMBER() or RANK() window functions.

Click to use

💾 Storage

Table Size & Row Counts

Analyze database storage usage, table sizes, and row counts for capacity planning.

Click to use

📆 Comparison

Year-over-Year Comparison

Compare metrics across different time periods with percentage change calculations.

Click to use

🐢 Diagnostics

Slow Query Detection

Identify long-running queries and performance bottlenecks in your database.

Click to use

New Connection

Database Type

Connection Name

Host

Port

Database Name

Username

Password

SSL

Schema

Timeout (sec)

Connection Type

Version

Client

Service Name

Or SID

Use Wallet (Cloud)