Is there a possible add-on that will simplify the user experience when creating a SQL statement? More specifically, is there a GUI that would allow the user to create a SQL statement similar to ArcMaps's Query Builder where pre-built function keys and data specific variables appear in the query window? CartoDB is an excellent fit for my client, however the SQL function is a little daunting to them.

I'm very new to CartoDB, but did a fair amount of research for potential solutions without any luck. I did researched SQL API tool, but it is my understanding that the API only interacts with the data table by Inserting, Deleting, and Updating the data?

  • 1
    Did you take a look at the CartoDB filter tool? It applies SQL queries in the back but for beginners in this SQL world it's just selectors and buttons to play with.
    – iriberri
    Dec 10, 2015 at 11:27
  • Thanks iriberri! I didn't realize that the filter tool creates a SQL statement. This will serve my purpose, thanks!
    – pac_co
    Dec 10, 2015 at 17:10
  • Thanks for the feedback! I'm then moving the comment to an actual answer. :-)
    – iriberri
    Dec 11, 2015 at 11:52

1 Answer 1


In the right toolbar of the CartoDB Editor there's an option available for filtering data: it allows to select the column in which the information is, and then, depending on the type of the data, you can set which values you want to show and which not.

The filters are creating a SQL query in the back. If after applying a filter you go to the SQL tab you will see that the options that the user selected by means of user-friendly buttons are actually a SQL query that the user can also edit.

There's a tutorial about it here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.