Docs/Database

Database Manager

FreePro: lifted quotas

SQL + NoSQL client + schema designer + monitor + backups + AI assistant — all in one module. 9 supported engines and a real PostgreSQL 18.2 running inside the app, no external server or internet needed.

PostgreSQL 18.2 running inside the app

Not a wrapper: real PostgreSQL binaries for Android (`postgres`, `psql`, `initdb`, `pg_ctl`). Pocket Code bundles them in the app and extracts them to its own storage on first use. The server boots in seconds because it ships with a pre-built data directory — no waiting on a typical `initdb`.

•No root, no Termux, no network — it all ships in the app
•Supports arm64 and armeabi-v7a — from modern phones to older devices
•You can create multiple databases inside the local server (1st free, more on Pro)
•Access via Unix socket, not TCP localhost — dodges firewalls on some OEMs
•The MariaDB engine is wired in code but not bundled yet

Supported engines

Engine	Type
Local SQLite	Local · relational SQL
Embedded PostgreSQL	Local · real binaries in the app
Neon	Serverless PostgreSQL
Supabase	Managed PostgreSQL
PlanetScale	Serverless MySQL
Turso	Distributed SQLite
MongoDB Atlas	NoSQL · documents
Firestore	NoSQL · documents
Upstash Redis	Key-value · serverless

Connections

Each connection has an environment tag (production, staging, development, testing, local) with colour, a status badge (connected, error, etc.) and folders to organise.

Paste your connection string

Paste `postgres://user:pass@host/db?sslmode=require` and the app auto-fills every field

SSH tunnel

Host, port, username with password or private key

SSL/TLS

5 modes from disable to verify-full + custom CA certificate

Connection pooling

Min/max connections, idle timeout, keep-alive

Proxy

HTTP, SOCKS4, SOCKS5 with optional auth

Test connection

Checks the connection and shows latency before you save

Encrypted credentials

Passwords are encrypted on-device and never appear on screen

Cloud providers

For Neon, Supabase, PlanetScale, Mongo Atlas, Turso or Upstash, the app browses your account and lists projects without needing the connection string

Data Viewer

The richest screen in the module. Paginated table with everything you expect from a desktop client, adapted to mobile.

•Sort per column (ascending, descending, none)

•Filters with =, !=, <, >, LIKE, IN, BETWEEN, IS NULL…

•Text search over visible columns

•Inline editing committed in batch (not a round-trip per cell)

•JSON side panel for JSONB / nested objects

•Row detail screen with every value formatted

•Show / hide / pin columns, resize width

•Tap an FK value → jumps to the target row

•Insert, duplicate or delete row + batch delete

•Automatic masking for email, password, token, etc. columns

•Visual widgets on columns with metadata: stars, progress, colour, sparkline…

•Export to CSV, JSON, SQL INSERT, full SQL or Markdown

Query Console

Multi-tab editor designed for mobile — with SQL symbol bar, autocomplete and an optional AI assistant.

•Multiple query tabs at once (Free: 2 · Pro: unlimited)
•Format SQL (pretty-print)
•Run all · run selection · cancel in-flight query
•Editor undo / redo
•Horizontal bar with SELECT, FROM, WHERE, =, *, ; etc. — inserts at the cursor in one tap
•Named parameters (`:user_id`) with a bind dialog before running
•Autocomplete for keywords, tables, views, columns, functions and your own snippets
•Results with colour-coded execution time (green fast, orange middle, red slow)
•Copy results as CSV, JSON, SQL or Markdown
•Saved queries with folders and automatic history of everything run

AI SQL Assistant

Describe the query in natural language and the AI generates the SQL, explains it, offers alternatives and warns you if it'll be slow. Keeps history of which prompts gave you good queries.

Free: with your own Gemini account (BYOK / OAuth). Pro: any unlocked provider by connecting your own API key. Pocket Code adds no credits — usage runs on your provider account.

Schema Designer + 7 generators

Full visual designer: canvas with zoom and pan, drag tables, connect mode for foreign keys, undo/redo, step-by-step wizard with templates (ecommerce, blog, SaaS) and export to 7 formats.

SQL DDL

CREATE TABLE / INDEX / ALTER

Room (Android)

Kotlin @Entity

Prisma

schema.prisma

TypeORM

TypeScript @Entity

Django

Python models

JSON Schema

Validation

DBML

dbdiagram.io

On top of that there's the ER diagram on the live schema: nodes = tables, lines = foreign keys with cardinality (1:1, 1:N, N:N), minimap for large diagrams and image export.

Safe mode, backups and monitoring

Safe mode

Dangerous operations (DELETE without WHERE, DROP, TRUNCATE, ALTER DROP COLUMN, UPDATE without WHERE) are intercepted and a dialog shows the full SQL, the rows that will be affected and a mandatory confirmation.

You can turn it off with a toggle if you need to.

Backups

• 4 formats: SQL dump, pg_dump, binary, CSV
• 4 destinations: local, Google Drive, Firebase Storage, cloud storage (S3/R2/B2)
• History with size, table count and status
• Scheduled (hourly, daily, weekly) with retention — Pro

Monitoring (5 tabs)

• Active queries with Kill button
• Slow query log with configurable threshold
• Index usage (unused / over-used)
• Connection monitor: latency, QPS, active connections
• Alerts: rows, duration, DB size, error rate

Security — masking, roles, biometric

Masking only affects how data is rendered, it does not modify anything in the database. Default rules auto-detect columns like `email`, `password`, `token`, `secret`, `api_key`.

Mask style	Example
Full mask	••••••••
Partial email	j••@gmail.com
Partial phone	+34 6•• ••• 789
Initials	J••• D••
Truncated hash	a3f5… (SHA-256)
Redacted	[REDACTED]

You can also read the engine's role list (Postgres `pg_roles`, MySQL `SHOW ROLES`, etc.), GRANT and REVOKE from the UI, and require biometrics (fingerprint, face or PIN) before running DELETE/DROP/TRUNCATE, opening production-marked connections or viewing masked columns in clear.

Charts, dashboards and visual EXPLAIN

Charts and dashboards

Any query result can become a chart: bar, line, pie, scatter or heatmap. Multi-series. You can pin it as a widget on a reorderable dashboard (Pro).

Visual EXPLAIN plan

EXPLAIN output is rendered as a tree with cost and estimated rows colour-coded. "Explain with AI" button so the assistant translates it to natural language and suggests indexes. Works with Postgres, MySQL and SQLite.

NoSQL with dedicated screens

NoSQL formats are not crammed into the SQL viewer: each has screens designed for its model.

Firestore

• Collections, documents and subcollections browser
• Visual query builder with every operator
• Per-document field editing

MongoDB

• mongosh-like shell — run `db.users.find({...})` directly
• Visual aggregation pipeline builder ($match, $group, $lookup, $facet…)

Redis (Upstash)

• KV browser filterable by type (string, list, set, zset, hash, stream)
• redis-cli-style CLI with every command
• Live monitor (command stream)

Free vs Pro

Feature	Free	Pro
Module access and the 9 engines	✅	✅
Embedded PostgreSQL + 1st local database	✅	✅
Query editor, data viewer, ER diagram, schema designer and masking	✅	✅
Saved connections	1	Unlimited
Saved queries	5	Unlimited
Simultaneous query tabs	2	Unlimited
Tables per database	4	Unlimited
Databases inside the local PostgreSQL	1	Unlimited
Schema templates	3	Unlimited
Dashboard widgets	—	✅
Schema diff + migration scripts	—	✅
Scheduled backups	—	✅

The 4-tables limit on Free is global: it covers creation from the form, the designer, DDL run in the console, the schema wizard, the mock-data generator and CSV import. It can't be bypassed by writing raw SQL.

Module statistics

Supported engines

Schema generators

Masking styles

Chart types

Backup formats

25+

Mock data types

Visual Designer