Sequel Pro Tips: table filters and auto-suggest

Sequel Pro is great, and there are a few tricks to make it even greater. If you have a database with a lot of tables then the table filter field is useful:

A neat tip is that you can use the pipe character as a logical OR operator, so you can show tables that match several conditions. Below is post|comment – tables that match post or comment:

Very handy if you have to swap between tables that are lost in a big list. You can chain together many filters in this way.

Another nice feature is the SQL auto-suggest. From the query tab, press escape as you are typing out a table or column name:

A box appears with matching suggestions. You can use cursor up/down to move between suggestions, and enter to select.

2 comments

  1. As I just found out, one is able to use some sort of regular expressions in the filter box as well… for example, filtering on “colour” in a database containing the tables “colour” and “colourful” will leave both tables visible. Instead, filtering on “colour$” will filter out “colourful”…

Leave a comment

Your email address will not be published. Required fields are marked *