PopSQL Reviews & Product Details

- User Interface. It's smooth, modern and easy to use.

- Easy to setup connections

- Parameterized Queries

- SQL query autocomplete suggestions

- Schema introspections

I started using PopSQL almost 2 years ago, and it's always my go-to for querying a relational database. I first learned about it in a freecodecamp video on learning SQL, and having tried over a dozen other market offerings for SQL clients, I can confidently say that PopSQL is the best out there!

The user interface is one of its strongest points, having a sleek, responsive and reactive layout that keeps the important elements in focus. Outdated UIs like pgAdmin, dbeaver and mysqlworkbench do not have the same smoothness or UX.

The parameterized queries are a blessing for plugging in values through a dropdown, selection or otherwise. The introspection is fast, and shows all relevant data such as column names and types in milliseconds! Review collected by and hosted on G2.com.

While I'm aware that PopSQL has more features like Dashboarding, query alerts and others, I just don't use them as much, and just prefer it as a reliable SQL client that can help me get my database work done with the least amount of effort. Review collected by and hosted on G2.com.

I like the below things most in PopSQL:

1) It is very user friendly.

2) The interface is very simple and easy to use. There is no unnecessary stuff which is not needed.

3) In a single application we can access to both Snowflake, DBT and many more.

4) Unline other applications we don't need to install Python, other python connector and create virtual enviroment.

5) We can create new GIT brances and change branches very easily. Review collected by and hosted on G2.com.

Asd of now there is nothing that I can say I dislike about PopSQL. Everything is very good Review collected by and hosted on G2.com.

PopSQL has a user interface that's easy to navigate resembling the smooth experience of using Mac software.

The ability to run Ad Hoc SQL analytics and share data is a game changer, for my team. I can effortlessly create queries to retrieve data, schedule tasks and share the results with my colleagues. This feature saves us time on tasks and empowers advanced users to access relevant data effortlessly.

The option to organize SQL logic into folders and subfolders promotes an approach to saving and accessing code. It enhances our teams data literacy by facilitating collaboration reviewing code and sharing knowledge.

I can connect PopSQL with production databases such as PostgreSQL, Databricks, Snowflake and BigQuery. This flexibility enables me to access and query data from sources while also performing checks for identifying any inconsistencies, between datasets. Review collected by and hosted on G2.com.

Although PopSQL usually provides an experience there have been an instances where the data sharing feature didn't function properly. A few team members noticed that the Excel files exported appeared to be, in disarray. However I'm happy to report that the PopSQL team has taken measures to address this problem. It appears to have been resolved in recent updates. Review collected by and hosted on G2.com.

1- Query Version Control: it allows users to track changes and collaborate seamlessly with team members on data queries 2- Database Connection Management: it has the ability to manage multiple database connections within the platform 3- Database Support: it supports a wide range of popular databases, making it versatile for users working with different database systems 4- Customer Support: it has excellent customer support Review collected by and hosted on G2.com.

1- Limited Integration Options: there are limited integration options and users want more integration options with third-party tools and platforms to streamline their workflow 2- Performance Issues: there are some performance issues when users work with large datasets and complex queries 3- Pricing: the cost of this platform is a bit high compared to platforms of the same level Review collected by and hosted on G2.com.

As a developer, I love PopSQL's scratchpad. Very clean interface to write queries and see results on the right of the screen. It also shows you results from previous runs of queries. You can write multiple queries and it only runs the one where your cursor is. I love this because I haven't deleted any of my old queries and can quickly grab and reuse them.

The Slack integration is very neat. You can easily set it up to run queries every x minutes and notify you in Slack if rows are returned or not. This has been extremely useful in monitoring our DB for unexpected states.

Collaboration works similar to Google docs. Works as you would expect.

Some of my coworkers use it to create charts and other visualizations which look pretty nice too. Review collected by and hosted on G2.com.

I don't think I dislike anything. It's a great product! Review collected by and hosted on G2.com.

It is very easy to use and collaborate on thanks to an easy sharing button. I like that even though it is not a BI tool per se, it has quite good chart capabilities. What I liked the most on the most recent update is its new AI capabilities, as generating a title and a description is something that most of the time we do not do and suggested fixing errors helps a lot with syntax errors. Version history is great as there is no need to remember what you changed beforehand, making it a lot easier to go back into previous versions. Having a dark mode is always greatly appreciated. Review collected by and hosted on G2.com.

Looking for a specific column in a table is hard as it does not let you filter by table.column. You can only look for either a table or a column. Even though chart and dashboard capabilities are quite good for a sql runner it still have lots of room for improvement. Once you delete a query there is no trash bin where you could potentially recover that query. Review collected by and hosted on G2.com.

What I enjoy about PopSQL is it is easy to use and easy to facilitate quick reporting and running queries.

I do not spend much time writing and re-writing new custom queries. Instead, I set up recurring queries to run on a scheduled cadence. It saves me so much time! Even the queries I do not use on a scheduled basis, I keep open as separate tabs. These tabs have saved me over and over.

Speaking of which, the general structure, format, and UI is lovely. It's simple and straightforward - if I cut down all the frills I would normally associate with similar tools, it's exactly what PopSQL has made itself out to be. Buttons are clearly detailed, custom SQL box is simple to expand or contract, and the results are readily available.

The hotkeys are great - I hate having to click around a screen. If my hand comes off the mouse, I have lost. And thankfully, PopSQL helps by having simple to use, easy to understand, and easily accessible hotkeys.

Also, I really appreciate how I can swiftly switch from one database to another. In some other tools, I have had challenges in syncing various DB's, and switching between them took more time than I had in the day. Now, I can go to the drop down in the top right, find the right database/warehouse, and run the queries or reports I need to run. Review collected by and hosted on G2.com.

The only thing I wish was different about PopSQL is being able to run schedule exports without queries being public. Occasionally I come across a non-public report I wish to export but am unable to without it being public. In a big organization, it's hard to find the owner! Review collected by and hosted on G2.com.

Easy-to-use graphics for seamless integration into presentations, and helpful exports to build out additional information. Review collected by and hosted on G2.com.

We have had a few timeouts on volume, but overall has been an incredibly helpful tool for our business. Review collected by and hosted on G2.com.

1-Multiple Database Support: This flexibility allows users to connect to various databases from a single interface, making it convenient for developers and data analysts working with multiple database systems.

2-Query Version Control and Collaboration: It provides features for version control and collaboration on SQL queries.

3-Database Connection Management: It offers efficient database connection management, allowing users to save and organize their database connections. Review collected by and hosted on G2.com.

1-Limited Database Support: If you work with specialized databases that are not supported by PopSQL, users may face limitations.

2-Costing: The pricing structure is relatively high compared to other SQL query tools.

3-Integration Limitations: It has limited integration options with other data analysis or visualization tools. Review collected by and hosted on G2.com.

The collaborative nature of PopSql allowed us to stop the redundancies when creating queries. Another amazing feature is all the export options provided, allowing for automations when combined with their scheduling feature. Review collected by and hosted on G2.com.

The search bar is pretty slow, and tends to freeze the whole system when starting to write, should feel more natural. Another little thing I would change is the default 100 limit that tends to create errors especially against new users. Review collected by and hosted on G2.com.