TablePlus Documentation
  • Overview
  • Getting Started
  • GUI Tools
    • The Interface
      • Quick Look
      • Menu
      • Toolbar
      • Left sidebar
      • Right sidebar
      • Console Log
      • Query Editor
      • Multi Tabs / Workspaces / Windows
    • Open Anything
    • Code Review & Safemode
      • Code Preview
      • Commit changes
      • Discard changes
      • Safe mode
    • Connections & Command Line (CLI)
    • Database
    • Working with Table
      • Table Basics
      • Row
      • Column
      • Constraint
      • Index
      • Trigger
    • Filter
    • Database Objects
      • Function
      • Procedure
      • View
    • Import & Export
    • Backup & Restore
    • User Management
    • Metrics board
  • Query Editor
    • Editor Basics
    • Multiple Carets
    • Query Favorite & Keyword Binding
    • Query History
    • Streaming Results & Async Loading
    • Autocomplete
    • Split Panes
    • Split Results into Tabs
    • Working With Query Results
    • Format query (beautify/minify/uglify)
    • Query Parameters
    • Customize Query Editor
  • Preferences
    • General
      • Application
      • Table Data
      • SQL Editor
      • CSV File
      • Connections
    • Fonts & Colors
    • Crash & Security
    • Keymap
  • Utilities
    • Plugin
    • DBngin
    • Shortcut Keys
    • Licensing
    • Troubleshooting
Powered by GitBook
On this page

Was this helpful?

  1. Query Editor

Query Parameters

PreviousFormat query (beautify/minify/uglify)NextCustomize Query Editor

Last updated 1 year ago

Was this helpful?

TablePlus supports adding query parameters. 1. In Comment

You can use the comments to tell TablePlus to draw a chart, for example: -- TablePlus BarChart x: a, y: b SELECT 1 as a, 2 as b;

This query will draw a chart base on the comment instructions. You don't need to enable it, this feature is always on by default. 2. In Queries

By default, TablePlus disables this feature. You can change the query parameter options by clicking on the config/setting button at the bottom left of the editor and choose Query params options:

  • Select/unselect Enable query params to enable/disable query parameters.

  • Change query param Regex between 4 variables:

    • :[\w.]

    • %[\w.]+%

    • \?

    • \$\{[\w.]+\}