Naming, Organizing, and Searching Queries

Once you start naming your queries and organizing them in folders, not only will you be able to find your work in the future, but your co-workers will be able to leverage your work as well. Here are some tips to stay organized and productive with PopSQL:

  1. Give your queries a good name. For example, Week over week user growth, Recent email opens, Past due invoices, etc.
  2. Put related queries in a folder.
  3. Quickly find queries with the fuzzy finder by hitting Cmd+K on macOS or Ctrl+K on Windows/Linux.

Here are some examples of folders and queries we have at PopSQL:

  • Billing and Subscriptions

    • Who are the active users in an organization?
    • How active is an organization?
    • Organizations that are past due
    • Who are the billing admins?
  • Metrics

    • How many students do we have?
    • Users per day
    • Organizations per day
    • Which database clients are most popular?
  • Organizations

    • Recent organization signups
    • Look up an organization by email domain
    • Look up an organization by name

Cookie settings