Skip to main content
TablePro supports two URL-based entry points: standard database URLs (mysql://, postgresql://, etc.) and the custom tablepro:// scheme.

​
Database URLs

Open any database connection directly using its standard URL. Works from the terminal, scripts, Alfred, Raycast, or any app that can open URLs.

​
Supported Schemes

SchemeDatabase
mysql://MySQL / MariaDB
postgresql://, postgres://PostgreSQL
mongodb://, mongodb+srv://MongoDB
redis://, rediss://Redis
mssql://, sqlserver://SQL Server
sqlite://SQLite (local file path)

​
URL Format

scheme://[username[:password]@]host[:port][/database][?param=value]

​
Examples

# MySQL
open "mysql://root@localhost/mydb" -a TablePro

# PostgreSQL with port and database
open "postgresql://[email protected]:5432/analytics" -a TablePro

# MongoDB
open "mongodb://localhost:27017/mydb" -a TablePro

# Redis
open "redis://localhost:6379" -a TablePro

# SQLite (local file)
open "sqlite:///Users/me/data/app.db" -a TablePro
TablePro checks if a saved connection matches the URL. If found, it reuses that connection. If the connection is already open, the existing window comes to front. Otherwise, a temporary connection is created.

​
Query Parameters

Pass additional options as query parameters:
ParameterDescription
tableOpen a specific table after connecting
filter_column, filter_operation, filter_valueApply a filter on the opened table
conditionApply a raw SQL WHERE condition
schemaSwitch to a specific schema (PostgreSQL) or database (MySQL) after connecting
# Open a table with a filter
open "mysql://root@localhost/mydb?table=users&filter_column=status&filter_operation=equal&filter_value=active" -a TablePro

# Open with a raw SQL condition
open "postgresql://admin@localhost/mydb?table=orders&condition=total%20%3E%20100" -a TablePro

# Switch schema on connect
open "postgresql://admin@localhost/mydb?schema=reporting" -a TablePro
Passwords can be included in URLs (mysql://user:pass@host/db), but avoid sharing URLs that contain passwords. Prefer saved connections with Keychain-stored passwords.
TablePro registers a tablepro:// URL scheme for opening connections, tables, and queries from your browser, terminal, Slack messages, or any app that supports links.

​
URL Patterns

​
Open a Connection

tablepro://connect/{name}
Opens the saved connection matching {name}. If no match is found, an error alert appears. 
open "tablepro://connect/Production"

​
Open a Table

tablepro://connect/{name}/table/{table}
tablepro://connect/{name}/database/{db}/table/{table}
Connects and opens the specified table. The second form targets a specific database on the connection. 
open "tablepro://connect/Production/table/users"
open "tablepro://connect/Production/database/analytics/table/events"

​
Open a Query

tablepro://connect/{name}/query?sql={encoded_sql}
Connects and opens a new query tab with the SQL pre-filled. The SQL must be percent-encoded. 
open "tablepro://connect/Production/query?sql=SELECT%20*%20FROM%20users%20LIMIT%2010"

​
Import a Connection

tablepro://import?name={n}&host={h}&port={p}&type={t}&username={u}&database={db}
Creates a new saved connection and opens the connection form for review. You can add a password before connecting. 
open "tablepro://import?name=Staging&host=db.example.com&port=5432&type=postgresql&username=admin&database=mydb"
Required parameters: name, host, type Optional parameters: port (defaults to the database type’s standard port), username, database Supported type values: MySQL, MariaDB, PostgreSQL, SQLite, MongoDB (case-insensitive).

​
Terminal Usage

Use the open command to trigger deep links from your terminal: 
# Connect
open "tablepro://connect/Production"

# Open a specific table
open "tablepro://connect/Production/table/users"

# Run a query
open "tablepro://connect/Production/query?sql=SELECT%20count(*)%20FROM%20orders"

# Import a new connection for review
open "tablepro://import?name=Dev&host=localhost&port=3306&type=mysql&username=root&database=app"