Capabilities

Full Technical Feature Matrix

Explore the complete technical specifications and engineering features powering the PocketSQL runtime.

SQL Language & Execution Engine

Comprehensive CRUD & Complex Joins

Full implementation of `SELECT`, `INSERT`, `UPDATE`, `DELETE`, and `REPLACE INTO`. Perform relational multi-table `INNER JOIN`, `LEFT OUTER JOIN`, `RIGHT OUTER JOIN`, and Cartesian `CROSS JOIN` operations with subquery filtering.

SELECT u.name, o.total FROM users u LEFT JOIN orders o ON u.id = o.user_id;

Analytical Window Functions

Execute advanced analytical partitioning queries with `PERCENT_RANK()`, `NTILE()`, `DENSE_RANK()`, and `ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...)` without loading datasets into client memory.

SELECT id, score, NTILE(4) OVER (ORDER BY score DESC) as quartile FROM leaderboard;

Strict Constraint Enforcement

Relational integrity is guarded with `PRIMARY KEY`, `FOREIGN KEY` (with `ON DELETE CASCADE` and `SET NULL`), `UNIQUE`, `NOT NULL`, and custom boolean `CHECK (...)` expression validation.

Temporal & Auto-Timestamp Triggers

Automatic timestamp updating with `DEFAULT CURRENT_TIMESTAMP` and `ON UPDATE CURRENT_TIMESTAMP`. Precise ISO-8601 millisecond date calculations.

Interactive Terminal Console

JetBrains Mono Typography

High-legibility programming font tailored for mobile screens with clear distinction between 0/O, 1/l, and aligned table borders.

Real-Time Autocomplete

Powered by `SqlKeywordSuggester.java`. Intelligently suggests keywords, table names, and column identifiers as you type in real time.

200+ Built-in Help Topics

Type `HELP ;` (e.g., `HELP SELECT;`, `HELP JOINS;`) for instant syntax documentation without needing an internet connection.

Embedded HTTP & TLS REST API Server

Android Foreground Service

Runs continuously in the background with persistent notification status. Features a one-tap "Stop Server" toggle directly from your phone's notification shade.

Auto Port-Failover (8080 - 8099)

If port 8080 is utilized by another service, PocketSQL automatically scans incrementally and binds to the first free port up to 8099 without crashing.

On-Device TLS 1.3 Generator

`AndroidCertGenerator.java` creates self-signed 2048-bit RSA X.509 certificates directly on the device, providing secure HTTPS connectivity over untrusted local Wi-Fi.

Scoped Bearer API Keys

Generate granular tokens with read-only or read/write privileges scoped to individual databases, managed via `SqlApiKeyManager.java`.

40+ MySQL System Tables Emulation

information_schema

`TABLES`, `COLUMNS`, `SCHEMATA`, `STATISTICS`, `KEY_COLUMN_USAGE`, `ROUTINES`

mysql

`user`, `db`, `tables_priv`, `columns_priv`, `general_log`, `slow_log`

performance_schema

`threads`, `events_statements_current`, `table_io_waits_summary_by_table`

sys

`version`, `metrics`, `statement_analysis`, `schema_table_statistics`

Export & Import Engine

Raw .sql DDL & DML Dumps

Export entire databases or selected tables into standard `.sql` script files ready to be imported directly into MySQL, MariaDB, or PostgreSQL.

Encrypted SQLite & SQLCipher (.db)

Export databases into standard SQLite binary format or encrypt with SQLCipher 256-bit AES for zero-knowledge data sharing.

Formatted Excel Spreadsheets (.xlsx)

Generate stylized Microsoft Excel workbooks on the phone with styled column headers and auto-adjusted cell widths.

ZIP-Compressed CSV Archives

Batch export all tables into cleanly formatted comma-separated `.csv` files bundled inside a lightweight `.zip` archive.

Mobile Security & Performance

AES-256 Android Keystore

All master configurations and API secret keys are encrypted with hardware-backed AES-256 GCM (`EncryptedSharedPreferences`).

Play Integrity Verification

`AppIntegrityManager.java` verifies that the running binary has not been tampered with or repackaged with malicious injections.

Thread Priority Scheduler

Background execution runs on prioritized background threads to ensure your phone's UI never stutters, even under heavy query execution.

Ready to Experience PocketSQL?

Download the APK directly or install the verified build from Google Play Store.

Download Releases → Read API Documentation