Database Manager

Supported engines

Native PostgreSQLPremium

Pocket Code includes a native PostgreSQL engine that runs directly on the device. No external server or internet connection needed.

-- Crear base de datos local
CREATE DATABASE myapp;

-- Crear tabla
CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Insertar datos
INSERT INTO users (email) VALUES ('dev@example.com');

-- Consultar
SELECT * FROM users;

Connect remote database

1. 1Open the Database module.
2. 2Tap "New connection".
3. 3Select the engine (PostgreSQL, MySQL, MongoDB…).
4. 4Enter host, port, database name, username and password.
5. 5Tap Test connection and then Save.

Credentials are stored encrypted on the device using Android Keystore.

Query editor

• •SQL autocomplete with table and column names
• •Syntax highlighting for SQL, NoSQL and native query languages
• •History of executed queries (10 free — Premium: unlimited)
• •Saved queries (5 free — Premium: unlimited)
• •Multiple query tabs (2 free — Premium: unlimited)
• •Paginated table results for large datasets
• •Export results to CSV or JSON
• •Explain plan to analyze query performance

Premium features