Skip to main content

​
iOS Shortcuts

TablePro for iOS exposes App Intents, so you can add data to a database table from the Shortcuts app, the Share Sheet, or by voice. The actions connect to a saved connection and insert the rows in the background, without opening the app. This is iOS only. On macOS, use the URL scheme and MCP.

​
Actions

ActionUse it for
Add Row to TableInsert a single row.
Add Rows to TableInsert many rows from a JSON array, CSV text, or a file.
Both actions share the same pickers:
  • Connection: one of your saved connections. Relational databases only (MySQL, MariaDB, PostgreSQL, Redshift, SQL Server, SQLite, DuckDB).
  • Database or Schema: optional. Leave it empty to use the connection’s configured database. On schema databases like PostgreSQL it lists schemas; on others it lists databases.
  • Table: the table to insert into. The list is read from the chosen connection.

​
Data formats

The row data is matched to the table’s columns by name. A column you don’t include is left out of the insert, so the database applies its default (an auto-increment primary key, for example).

​
JSON

A single object is one row: 
{ "title": "TablePro docs", "url": "https://docs.tablepro.app", "tags": "reference" }
An array of objects is many rows (Add Rows to Table): 
[
  { "title": "First", "url": "https://example.com/1" },
  { "title": "Second", "url": "https://example.com/2" }
]
null inserts a SQL NULL. Numbers and booleans are inserted as text. Wrap very large or high-precision numbers in quotes so they stay exact. A bare JSON number past 64-bit integer range (a long unsigned ID, for example) is read as a floating-point value and loses digits; "18446744073709551615" as a string keeps every digit. A Shortcuts Dictionary action passes straight into the Data field, so you can build the row visually with key/value pairs instead of typing JSON.

​
CSV

The first row is the header and names the columns: 
title,url
First,https://example.com/1
Second,https://example.com/2
Quoted fields with commas and embedded quotes follow the usual CSV rules. Pass CSV as text in the Data field, or as a file in the File field.

​
Result

Each action returns the number of rows inserted, so you can show it or use it in a later step, and speaks a short confirmation (“Added 2 rows to bookmarks.”).

​
Notes

  • The action requires the device to be unlocked, since it reads the connection password from the Keychain.
  • A read-only connection refuses the insert with an error. A connection set to Confirm Writes asks you to confirm before the rows are added.
  • Add Rows to Table runs the batch in one transaction on databases that support it, so a row that fails rolls the whole batch back instead of leaving a partial insert.
  • Data that maps to no columns (an empty object, for example) returns an error rather than reporting that it added nothing.
  • Up to 10,000 rows per run.