My Database Pro — a tour

SQLite on the phone, MySQL on a server, pictures on every record, and a PHP and HTML editor, a web view, an SSH terminal, your servers, QR and barcode tools and an AI assistant beside them — all in one app. Every picture below is a screenshot of the app itself, taken on a phone, in the order you would meet the screens.

Databases 1–4

The start screen lists every database — a file on the phone or a MySQL database on a server. The row of tools along the top is the same on every screen, and scrolls sideways to Servers, Tools and My Database Pro.

The database list — 1The database list Animals, Chinook and Products ship with the app. The database icon lights up wherever you are inside a database.

Database options — 2Database options Rename, duplicate, delete — and a password, which encrypts the whole file with SQLCipher.

Add a database — 3Add a database Create a new database on the phone, or connect to one on a MySQL server.

A MySQL connection — 4A MySQL connection Host, port, user and database, with SSL and certificates. Further down, under Pictures: where the record pictures live on the server.

Tables 5–8

Open a database and its tables are listed under a path line that always says where you are. Hold a row and drag it to put the tables in your own order. Import and Export sit in the bar as icons.

The tables of Animals — 5The tables of Animals Mammals and Birds, with + for a new table, import, export and ⚙ in the bar.

Jump to another database — 6Jump to another database The path line is also a menu: tap the database name and pick another one.

Table options — 7Table options Rename, duplicate or delete a table.

Table opened at start — 8Table opened at start Table Settings (⚙): pick the table the app opens on, or none.

Records 9–12

Every row of a table is a card, with its pictures along the bottom. Search it, tap a value to change it, and the change is written straight to the database.

Birds — 9Birds Ten birds, each with its own photographs, loaded a page at a time as you scroll.

Search — 10Search One word searches every column — “ar” finds Canary, Parrot and Sparrow. The <> beside it takes a real SQL condition.

Edit a value — 11Edit a value Type it, scan it from a barcode or QR code, read it off a photo — or make a QR code or barcode from it.

Add a record — 12Add a record A field per column, with the code and text readers above them.

Pictures & codes 13–20

Any record can carry pictures — kept beside the database on the phone, or on your own server for a MySQL database.

A record with pictures — 13A record with pictures Canary’s photographs along the card, and its name drawn as a barcode right on it. Hold a picture and drag to reorder them.

Add a picture — 14Add a picture From the gallery, or several in a row with the camera.

The viewer — 15The viewer A tap on a picture opens it full screen.

Take it out of the app — 16Take it out of the app Share a picture, save it to the phone, or send it to a server.

Select several — 17Select several Hold a picture still to select it, tap others to add them, and delete them together.

A QR code from a value — 18A QR code from a value Any value can be drawn as a QR code — shown on the card, or saved as one of its pictures.

A barcode from a value — 19A barcode from a value The same value as a barcode, with the text printed under it — ready for a label.

Codes on the record — 20Codes on the record The barcode shown on the card, the QR code saved among the photographs.

Post Settings & columns 21–26

The ⚙ on a table’s posts holds everything about that one table: its columns, its order, what is searched and how the cards look.

Post Settings — 21Post Settings Columns, sort order, searched columns, thumbnails and their size, and the camera and ✕ buttons on every card.

Sort by — 22Sort by Pick a column and a direction; the table opens in that order every time.

Columns — 23Columns The table’s structure: each column with its type. The eye hides a column from the cards; drag the grip to reorder; STRICT for the whole table.

Column options — 24Column options Rename a column, change its type, or delete it.

Add a column — 25Add a column Name, type, default and NOT NULL — the app rebuilds the table where SQLite has no ALTER for it.

Column types — 26Column types TEXT, INTEGER, REAL, BLOB and NUMERIC.

Export & import 27–30

A database, a table or a search result can leave the phone in a few steps — and come back the same way.

Where to — 27Where to Copy it to a MySQL server, update its web page on your server, upload it, save it or share it.

Which format — 28Which format A ZIP with the pictures, the SQLite file on its own, or a MySQL dump.

The name — 29The name The last step: what the file is called.

Import — 30Import A CSV, a ZIP with its pictures, or a SQLite file becomes a database on the phone.

SQL Query 31–37

Write any SQL against the database you are in — queries, updates, schema changes — and page through the answer.

A query — 31A query Birds and Mammals in one list with UNION ALL: 25 animals, sorted by name.

Which table — 32Which table The path line picks the table the editor starts from.

Asked first — 33Asked first A statement that changes data is shown back to you before it runs.

An update — 34An update …and then says how many rows it changed.

Export the answer — 35Export the answer The results leave the phone like anything else: saved, shared or uploaded.

AI in SQL Query — 36AI in SQL Query The round ✦ button: ask in plain words, and the query it writes goes into the box — it never runs on its own.

SQL Query Settings — 37SQL Query Settings Rows per page, asking before changes, word wrap, and the AI button.

AI 38–40

A chat for any question — including how the app itself works — with the model and the API key of your choice.

The chat — 38The chat Type or speak a question. The model you picked is shown under the title.

AI Settings — 39AI Settings Provider, model and your own API key, voice options, and whether ✦ sits on the tool row.

Providers — 40Providers Claude, Grok, Mistral, Gemini, OpenAI, DeepSeek, OrcaRouter, Puter — or a model on your own server.

Editor — TXT, PHP and HTML 41–48

A code editor with tabs, syntax colours and undo — and a real PHP interpreter inside the app, so a PHP page runs on the phone with no server.

Text — 41Text Plain notes, one tab each. Tabs and unsaved text are kept between visits.

PHP — 42PHP Highlighted PHP with line numbers, and the AI button for changes in plain words.

PHP, running — 43PHP, running Preview runs the file through PHP on the phone — here a working calculator.

A new file — 44A new file Name it, and the extension decides the language.

HTML — 45HTML A page about the birds, written on the phone.

HTML, shown — 46HTML, shown Preview draws the page as a browser would.

The editor menu — 47The editor menu Choose the language, open a file from the phone or straight off a server, save one or all, or upload a copy.

Editor Settings — 48Editor Settings Font size, line height, tabs, word wrap, line numbers, the reminder date and the colour theme.

Web View 49–53

A browser inside the app, for the pages you keep going back to.

Web View Settings — 49Web View Settings Ads blocked in this view, and a list of your own pages with a text size each.

A page open — 50A page open Read the SQLite tutorial without leaving the app.

Your pages — 51Your pages The globe in the bar opens the saved pages.

Google — 52Google Any address opens — here Google, with its search box, AI search and camera search.

A search — 53A search “sqlite join tutorial”, answered inside the app. A result opens in the same view, and ← goes back a page.

SSH Terminal 54–58

A shell on your own server, with a panel of saved commands that paste with one tap.

SSH connections — 54SSH connections The list starts empty; + adds a server.

A new connection — 55A new connection Name, host, port, user and password. A server’s key is remembered the first time, and a changed key is refused.

Saved — 56Saved A tap on the row opens the terminal on that server.

Connection options — 57Connection options Edit it, lock it with a password of its own, or delete it.

Terminal Settings — 58Terminal Settings Font size, the row of extra keys, and the AI button.

Servers 59–61

Your SFTP and FTP servers in one place — where pictures, pages and exports are uploaded, and whose files you can browse.

The server list — 59The server list Only the name and the protocol show; the address stays inside. A tap browses the files on it.

An SFTP / FTP server — 60An SFTP / FTP server Either protocol, the folders to upload into, and a button that tests the connection before anything is sent.

Server options — 61Server options Configure, duplicate or delete it.

Tools 62–64

Codes and text, without opening a database.

Codes and text — 62Codes and text Scan a QR code or barcode, make either one, or read the text off a picture.

Make a QR code — 63Make a QR code Type the text and the code is drawn as you type.

Print on A4 — 64Print on A4 Size and copies — or a whole page of them — then print it or save it as a PDF.

My Database Pro 65–71

The app’s own page: language, look, AI, backups and the guide — every setting opens its own picker, so the list stays a list of names.

My Database Pro — 65My Database Pro Language and appearance, AI Settings, and below them backups and help.

Backup and about — 66Backup and about Back up everything, restore it, protect the logins with a password, and the guide, privacy policy and log.

50 languages — 6750 languages The app in the phone’s language or the one you pick.

Dark mode — 68Dark mode The whole app, dark.

Back up everything — 69Back up everything Every database, its pictures, your logins and settings — saved, shared or uploaded.

Restore — 70Restore From a file on the phone or straight off a server.

How to — 71How to The full guide is inside the app and works with no connection.