# pgAdmin Reviews **Vendor:** pgAdmin **Category:** [Other IT Infrastructure Software](https://www.g2.com/categories/other-it-infrastructure) **Average Rating:** 4.1/5.0 **Total Reviews:** 73 ## About pgAdmin pgAdmin is a comprehensive, open-source administration and development platform for PostgreSQL, the world's most advanced open-source database. Designed to meet the needs of both database administrators and developers, pgAdmin offers an intuitive graphical interface that simplifies the management, querying, and analysis of PostgreSQL databases. Its cross-platform compatibility ensures seamless operation on Windows, macOS, and Linux systems, making it a versatile tool for diverse development environments. Key Features and Functionality: - Cross-Platform Support: Operates on Windows, macOS, and Linux, providing flexibility across different operating systems. - Comprehensive Database Management: Enables users to create, manage, and query all PostgreSQL objects through an intuitive graphical interface. - Powerful Query Tool: Features syntax highlighting, auto-complete, and graphical EXPLAIN options to optimize query performance. - Multiple Deployment Models: Offers both desktop mode with a dedicated runtime and server mode, supporting multiple users over the web. - Advanced Tools: Includes a schema diff tool for managing differences between schemas, an ERD tool for designing and documenting schemas, and a procedural language debugger supporting pl/pgsql and edb-spl. - Routine Maintenance Utilities: Provides auto-vacuum management, a monitoring dashboard, and on-demand backup, restore, vacuum, and analyze functions. - Extensive Documentation: Offers comprehensive documentation for both the pgAdmin application and PostgreSQL, facilitating ease of use and learning. Primary Value and User Solutions: pgAdmin addresses the complexities associated with PostgreSQL database management by offering a user-friendly, feature-rich interface that streamlines administrative tasks and development processes. Its cross-platform support and multiple deployment options cater to a wide range of user preferences and operational requirements. By integrating advanced tools for query optimization, schema management, and routine maintenance, pgAdmin enhances productivity and ensures efficient database performance. This makes it an invaluable resource for database administrators and developers seeking a robust and reliable PostgreSQL management solution. ## pgAdmin Reviews ### 1. Reliable, Feature-Rich pgAdmin for Everyday PostgreSQL Management but Not Easy to use **Rating:** 3.0/5.0 stars **Reviewed by:** Gaurang A. | Full Stack Developer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** February 20, 2026 **What do you like best about pgAdmin?** pgAdmin offers a strong set of features for PostgreSQL, including query execution, schema management, backups, and role control. It’s reliable and closely integrated with PostgreSQL, which makes it a dependable tool for day-to-day database operations. Implementation is fairly straightforward, especially given that it’s free and widely supported. For PostgreSQL users, it also tends to be used frequently as a natural part of regular workflow. **What do you dislike about pgAdmin?** The biggest drawback for me is ease of use, since it isn’t very intuitive. The UI feels cluttered, navigation can be confusing, and many common tasks require extra steps to complete. Performance also feels slow at times, especially when working with larger databases. Customer support is mainly community-based, which may not be enough for enterprise needs. Overall, the user experience comes across as outdated compared with more modern database tools. **What problems is pgAdmin solving and how is that benefiting you?** pgAdmin addresses the need to manage PostgreSQL databases through a graphical interface, allowing users to work with queries, schemas, and general database administration without relying solely on command-line tools. ### 2. Powerful Open-Source PostgreSQL GUI That Streamlines Database Management **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** April 30, 2026 **What do you like best about pgAdmin?** pgAdmin's intuitive query editor with syntax highlighting and auto-completion makes database management very efficient. The visual table designer and ERD tool save a lot of time when working with complex schemas. Being open-source and cross-platform is a major advantage for development teams. **What do you dislike about pgAdmin?** The interface can feel slow and resource-heavy when handling large datasets or running multiple queries simultaneously. The initial setup and configuration can be a bit complex for new users, and the connection management could be more streamlined for teams. **What problems is pgAdmin solving and how is that benefiting you?** pgAdmin solves the challenge of managing PostgreSQL databases without needing to rely solely on command-line tools. For our development team, it centralizes database administration tasks like schema design, query testing, and performance monitoring in one GUI, significantly reducing the time spent on database operations. ### 3. Clunky, Unfriendly UI That Needs a Serious Overhaul **Rating:** 0.0/5.0 stars **Reviewed by:** Abhishek S. | Data Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** April 21, 2026 **What do you like best about pgAdmin?** It does the job and works fine on older systems. **What do you dislike about pgAdmin?** The UI feels clunky and unattractive, and it’s not user-friendly at all. On macOS it lags, and it keeps crashing, especially when handling queries. Overall, it’s quite slow. **What problems is pgAdmin solving and how is that benefiting you?** I use it to run queries that help me answer business questions and make sense of the results. ### 4. Simplifies PostgreSQL Management with a Clean Interface **Rating:** 4.0/5.0 stars **Reviewed by:** Warit C. | Full-Stack Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 13, 2025 **What do you like best about pgAdmin?** I like pgAdmin for its simplicity and nice interface. It runs on every OS, which is really convenient. Compared to DBeaver, pgAdmin stands out for letting me quickly connect to databases and see data without needing to write SQL queries each time. I can also check data, tables, and views swiftly, and take screenshots of the view to share with others since it appears in a presentable format. Setting it up was quick and just needed the connection to the database, which was pretty straightforward. **What do you dislike about pgAdmin?** I had an issue with the export feature on Linux; I couldn't find the saved files and had to spend a couple of hours fixing it. I'd also improve the ability to keep passwords saved even when a connection fails, as it sometimes asks me to re-enter the same password I entered before. **What problems is pgAdmin solving and how is that benefiting you?** I use pgAdmin to quickly connect and manage databases without writing SQL queries each time. It presents data in a convenient, presentable format, and I can easily share screenshots. Its simplicity, interface, and cross-platform functionality enhance my workflow. ### 5. Easy Database & Cluster Management, But Not All Features Are Included **Rating:** 3.5/5.0 stars **Reviewed by:** Openidle D. | Software development agency, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** May 19, 2026 **What do you like best about pgAdmin?** That I can easily manage databases and cluaters **What do you dislike about pgAdmin?** All features not included in the database manager **What problems is pgAdmin solving and how is that benefiting you?** I can easily manage multiple databases without any hassle. ### 6. Reliable Database Backup and Restore Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Program Development | Small-Business (50 or fewer emp.) **Reviewed Date:** March 10, 2026 **What do you like best about pgAdmin?** It’s a good tool for restoring and backing up databases. **What do you dislike about pgAdmin?** The UI feels a bit outdated and could be updated to look more modern. **What problems is pgAdmin solving and how is that benefiting you?** As I mentioned, it’s good for backing up a database. ### 7. Easy to Use PgAdmin with Great Features, but Prone to Crashes When Offline **Rating:** 4.0/5.0 stars **Reviewed by:** Arvind T. | Technical Leader, Mid-Market (51-1000 emp.) **Reviewed Date:** October 17, 2025 **What do you like best about pgAdmin?** I have been using PgAdmin from last 10 years and from last couples of years used multiple versions of PgAdmin, easy to use and store the history query. You can import the table and export. Vacuum the table. **What do you dislike about pgAdmin?** Many times when internet connection down it crash. **What problems is pgAdmin solving and how is that benefiting you?** Now crashing issue solved and easy to maintain. ### 8. pg admin **Rating:** 4.0/5.0 stars **Reviewed by:** Mahesh B. | Backend developer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 03, 2025 **What do you like best about pgAdmin?** Pg Admins serve as an excellent tool for software engineers. The user interface, especially for queries, is very well designed and straightforward, making it easy to use. **What do you dislike about pgAdmin?** Sometimes the screen fluctuates, and we have to restart the pgAdmin app, which is irritating. **What problems is pgAdmin solving and how is that benefiting you?** The platform allows direct access to the database, making it easy to retrieve the specific data I need in the desired format. Additionally, it offers features that support business analytics, which is very helpful. ### 9. PgAdmin **Rating:** 4.5/5.0 stars **Reviewed by:** Khushi K. | System administrator - L1, Small-Business (50 or fewer emp.) **Reviewed Date:** February 08, 2025 **What do you like best about pgAdmin?** I like best about pgAdmin is a user-friendly tool that makes it easy to manage and organize PostgreSQL databases. **What do you dislike about pgAdmin?** I dislike about pgAdmin is that its interface is outdated and slow process for large database and little complex to use all features. **What problems is pgAdmin solving and how is that benefiting you?** pgAdmin helps me to simplifies PostgreSQL database management, making it easier to organize, monitor, and secure databases, which benefits me to save time and productivity. ### 10. Pg Admin Review **Rating:** 5.0/5.0 stars **Reviewed by:** Saranya K. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** November 08, 2024 **What do you like best about pgAdmin?** Managing data is easy and accessing it quickly.Can access all the data and can perform any action in that **What do you dislike about pgAdmin?** UI is little slow and uses many resources **What problems is pgAdmin solving and how is that benefiting you?** it is portable and easy to use ### 11. Worst SQL server **Rating:** 0.0/5.0 stars **Reviewed by:** Abhinav K. | Standup Comedian, Small-Business (50 or fewer emp.) **Reviewed Date:** October 09, 2023 **What do you like best about pgAdmin?** There is nothing to like about PGAdmin, it crashes time to time and sometimes its even fails to read the database. **What do you dislike about pgAdmin?** There is everything to dislike about this, on top of that this is not at all user friedly. Its user interface is wierd, Microsoft SQL is way better. **What problems is pgAdmin solving and how is that benefiting you?** Well it was supposed to solve my databse management problem, but insted it has give me more headaches. I am shifting to microsoft SQL. ### 12. Control of Databases with pgAdmin **Rating:** 4.5/5.0 stars **Reviewed by:** Satyendra S. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 04, 2023 **What do you like best about pgAdmin?** Easily Manage and Understand Postgres SQL Databases. No more complex queries; just a simple tool that shows you server, database, and table info, helping you find what you need quickly. **What do you dislike about pgAdmin?** Sometimes pgAdmin be slow and not very beginner-friendly due to a complex interface. **What problems is pgAdmin solving and how is that benefiting you?** I am using pgAdmin to set up my database when working on our service code and creating APIs. It helps us create and run database items easily. ### 13. Workbench for PostgreSQL Management and Administration **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** June 07, 2023 **What do you like best about pgAdmin?** 1.It makes it easy to manage postgres data. 2.good user interface 3.Provides sql editor 4.it offers tools for monitoring server activity 5. we can keep track of query performance for better efficiency from dbs **What do you dislike about pgAdmin?** 1.sometimes crashes 2.sometimes its difficult to connect with server **What problems is pgAdmin solving and how is that benefiting you?** it allows users to work on multiple databases provides efficient SQL editor allows administrators to manage roles,permissions and access controls ### 14. Good tool for beginners to database programming **Rating:** 4.5/5.0 stars **Reviewed by:** Shreeraj N. | RPA - Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** July 28, 2022 **What do you like best about pgAdmin?** Good tool for beginners to database programming. I learnt basic sql commands on pgadmin, which was a good experience. Utilises lesser RAM space **What do you dislike about pgAdmin?** Speed could be faster. Could use some advanced features like generating updates, inserts automatically. As of now we have to manually type the entire command, unlike other competitors. **What problems is pgAdmin solving and how is that benefiting you?** It is a good tool for teaching sql to new joinees and also for practising sql commands. It gives a better understanding of database programming. ### 15. Best PostgreSQL desktop client **Rating:** 4.0/5.0 stars **Reviewed by:** Arsalan K. | Technical Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** November 03, 2021 **What do you like best about pgAdmin?** Simple user interface. It almost requires no expertise to operate and get started. I am connecting to a remote database server. Open-source and free to use. Syntax highlighting for SQL. Option to compare two databases and generate differences between them. It is a compelling option when you want to migrate a database and want only the difference. **What do you dislike about pgAdmin?** You always have to start the client through a shortcut. It would be better to somehow configure it as a background process that starts up with the windows. There should be some macros to generate common SQL queries in fewer keystrokes. **Recommendations to others considering pgAdmin:** There are other options like Dbeaver where you can do a bit more like generate ERD of the database. **What problems is pgAdmin solving and how is that benefiting you?** I am connecting to remote database servers. You can add server groups and then servers for quick access. I am running SQL queries and finding query execution plans. I am exporting SQL results into CSV format. I am exporting backups into Plain, tar, or other formats. Support for extensions, and the most commonly used is crypto extension. ### 16. Honest review of PgAdmin **Rating:** 4.5/5.0 stars **Reviewed by:** Tarun R. | Backend Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 14, 2021 **What do you like best about pgAdmin?** It is a very nice tool to monitor databases especially if you are using Postgres SQL, It provides a lot of functionality in UI which you have to write queries if you want to do that in the Terminal. It gives an outlook of the servers, their databases, and then tables in the database which is very helpful in analyzing. It helps us to find dependencies, statistics, dependents, properties, etc. **What do you dislike about pgAdmin?** UI provides a lot of features but it still needs an upgrade design-wise, functionality is good enough but when it comes to design it can be more attractive and useful. **Recommendations to others considering pgAdmin:** I will recommend it if you are working on Postgre SQL, it will be very handy. **What problems is pgAdmin solving and how is that benefiting you?** I am using Postgres SQL in my organization and pgAdmin comes very handy when I want to get a whole picture of my DB's my schema's and their dependencies. It boost productivity and it very easy to do things with pgAdmin otherwise it will take a lot of time. ### 17. A reliable tool to manage postgres databases **Rating:** 4.0/5.0 stars **Reviewed by:** Danish M. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 06, 2022 **What do you like best about pgAdmin?** pgAdmin is a very easy-to-use tool for managing Postgres databases. I like the ease of importing and exporting databases. Also, its query builder tool is super helpful. **What do you dislike about pgAdmin?** I don't see much improvement in pgAdmin.It can add some intelligence in building queries and show suggestions to auto-complete the queries. Other than this,pgAdmin is a great tool. **What problems is pgAdmin solving and how is that benefiting you?** I am a software engineer and use pgAdmin to visualize Postgres databases for my day-to-day tasks. I often use it for importing and exporting data. It is beneficial in executing queries and testing them before I can use them in my project. ### 18. pgAdmin Review **Rating:** 4.0/5.0 stars **Reviewed by:** Jasmeet singh V. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 30, 2021 ### 19. pgAdmin review by Sunny **Rating:** 4.0/5.0 stars **Reviewed by:** Sunny H. | Software Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** September 29, 2021 ### 20. Easy database for local env **Rating:** 5.0/5.0 stars **Reviewed by:** Shubham M. | S, Small-Business (50 or fewer emp.) **Reviewed Date:** September 07, 2021 **What do you like best about pgAdmin?** The easy setup and installation process. Very easy to use with local env and test database connection and working. I also like the live graphs which show connections and sessions **What do you dislike about pgAdmin?** I hate to refresh the database after changes are made. Also it takes high memory, which slows performance. **What problems is pgAdmin solving and how is that benefiting you?** I am using Pgadmin for develping a full stack application and testing it using pgadmin database. ### 21. Review of pdAdmin **Rating:** 5.0/5.0 stars **Reviewed by:** Manzar A. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2022 **What do you like best about pgAdmin?** It is easy to use and navigate which helps in reducing the number and frequency of query writing and allows to run multiple different queries in different tabs. **What do you dislike about pgAdmin?** Sometimes it is a little slow and takes time to return the response of the query. The user interface is not easy to navigate which makes it difficult for beginners. **What problems is pgAdmin solving and how is that benefiting you?** We used his tool for writing queries and procedures to manage the Postgres Databases. ### 22. Best PostgreSQL database management tool **Rating:** 5.0/5.0 stars **Reviewed by:** Priyabrat Prasad M. | IT Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** December 07, 2021 **What do you like best about pgAdmin?** The GUI of pgadmin is straightforward to use and has really smooth navigation to view the DB objects. Importing and exporting database of database objects is seamless. It also dashboard for monitoring the database performance. **What do you dislike about pgAdmin?** Database imports from different versions can be a problem sometimes and have some small barriers for installation in servers. UI is a bit slow sometimes and sometimes crashes while opening. **What problems is pgAdmin solving and how is that benefiting you?** We are using pgadmin for setting up the database for the local setup of our service code. We use it for the API development process. We create and execute DB objects using pgadmin. ### 23. Easy Postgres DB Interface **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Sports | Small-Business (50 or fewer emp.) **Reviewed Date:** November 19, 2021 **What do you like best about pgAdmin?** Easy setup for Postgres database connection. The user interface allows user input without having the need to write SQL to manipulate constraints and alter the columns. It's easy to use. **What do you dislike about pgAdmin?** Only Postgres related database connection is able to be established. Other than that, there is no auto-complete for the type of queries input by the users based on the selected schemas, tables, and columns. **What problems is pgAdmin solving and how is that benefiting you?** The ability to connect to multiple databases, manage the databases, handle queries, view connection details. Our team is able to monitor the availability of the database itself. ### 24. Best development platform for PostgreSQL **Rating:** 5.0/5.0 stars **Reviewed by:** Omkar Vilas M. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about pgAdmin?** pgadmin is a potent query tool with a vibrant graphical user interface that highlights the queries. It's speedy and provides accurate data. It also supports procedural language and edb SQL database. We can do multiple deployments of databases without delay. It supports multiple platforms like MACOS, Windows, Linux **What do you dislike about pgAdmin?** It consumes high memory, which slows other applications. **What problems is pgAdmin solving and how is that benefiting you?** I am using Pgadmin every day for PostgreSQL database development. It's part of everyday work. It is a very convenient tool for PostgreSQL database development and supports client-server architecture. ### 25. A steep learning curve, but it is feature rich and in browser. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 11, 2021 **What do you like best about pgAdmin?** Pgadmin has all the functionality you would need to administer and view Postgres databases. I like that it is browser based for easy access. **What do you dislike about pgAdmin?** At times having it in a browser only gets annoying. It can get lost in your tabs. The query tabs are also a bit hard to navigate. **What problems is pgAdmin solving and how is that benefiting you?** I use Pgadmin to manage local DBs and to read remote databases. It's the best tool that's specific to Postgres. ### 26. Excellent Tool for Postgresql database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 02, 2021 **What do you like best about pgAdmin?** I like how it is easy to use, one can perform operations like insert row, delete row or edit row easily using gui tools which would've been difficult doing it with the commands **What do you dislike about pgAdmin?** I dislike how the web app gets very slow at times **What problems is pgAdmin solving and how is that benefiting you?** I use Postgresql database for my Django web development and pgadmin is the everyday tool I use to manage data in the db. Pgadmin increases my productivity and speed ### 27. Easy and full of features DB tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2021 **What do you like best about pgAdmin?** It does everything that SQL server does but easier. The tool is free without worrying about a license. **What do you dislike about pgAdmin?** It could be a little overwhelming at first. But once you get the hang of it is very easy. The UI could use some more improvements. **Recommendations to others considering pgAdmin:** Take you time with it. **What problems is pgAdmin solving and how is that benefiting you?** It solves the problem of managing one or more databases. Am easy Interactive way to query and update your database. ### 28. Pg admin for every database **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** January 06, 2022 **What do you like best about pgAdmin?** Creating tables, schema , databases are very easy. One who is learner can use this software and learn postgressql **What do you dislike about pgAdmin?** Nothing as such is there which I dislike about pgadmin **Recommendations to others considering pgAdmin:** Yes . Highly recommended **What problems is pgAdmin solving and how is that benefiting you?** Creating tables, schema databases . ### 29. pgAdmin for Code Learner **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Small-Business (50 or fewer emp.) **Reviewed Date:** October 28, 2021 **What do you like best about pgAdmin?** It is relatively user friendly and easy to find different tabs/actions **What do you dislike about pgAdmin?** It can feel cluttered when there are multple tabs open. **What problems is pgAdmin solving and how is that benefiting you?** Able to teach a class using pgAdmin and easily share and edit data ### 30. I am new user of Pgadmin it this is my startup to by using Sql Server and it helps me a lot. **Rating:** 5.0/5.0 stars **Reviewed by:** john matthew A. | Small-Business (50 or fewer emp.) **Reviewed Date:** September 24, 2020 **What do you like best about pgAdmin?** It can simply shows you all the options of every data table and also there is a features that really helps to become a better user . **What do you dislike about pgAdmin?** Everything is find and went well however I would rather suggest if it is possible to implement downloadable Sql Engine for Pgadmin so that the user will not use Pgadmin by just opening the browser. **Recommendations to others considering pgAdmin:** Yes I will recommend for everyone to use Pgadmin since it is Free and Very reliable and also scalable. and it is easy to understand and to learn as well. and very secured Application that is why I will really recommend Pgadmin and it is one of the best Sql Server in the world so Hands up for this. and I have use this less than a year and even I haven't experienced of using any Sql server I have easily learned it and PGadmin has their own documentation on how to setup especially the configuration and what is the pre requisite before using it and also there is a generated script on the document where they can help you to improve your skills step by step. so all you need to find is on the PGadmin I would really recomment this one especially for a Big organization it really helps them a lot. **What problems is pgAdmin solving and how is that benefiting you?** When start to make a query script there is an option for you to see the errors on logs. Then with that information I will be able to solve my problem specifically. ### 31. A very light weight Browser/web based PostgerSQL DB tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** October 15, 2020 **What do you like best about pgAdmin?** The fact that its an open source browser based tool, has my best interest. its fast, light weight and super simple to use. Cool features like auto population of boiler plate scripts on deamnd saves a lot of Postgers Script development time on the long run. Pretty much happy with the performance and user friendly layouts/designs. Believe i am gonna stick to it for a while. **What do you dislike about pgAdmin?** The version i am using (4.earlies) , i could not find the support feature for Relational diagram like ER generation. had to switch to manual efforts with Visio for creating the design. i could see a couple of posts online for its support on Relational Diagram design but had a hard time actually getting it. May be newer versions have it. **What problems is pgAdmin solving and how is that benefiting you?** This tool is best used for Database management for PostgerSQL. the layouts pgAdmin has provided are super simple to use, let it be quick auto populated DDL DML commands or its graphical representation of statistical resouece consumption, everything is easily accessable in tabular views. ### 32. My company database successfully created as PgAdmin **Rating:** 5.0/5.0 stars **Reviewed by:** Jessica M. | Small-Business (50 or fewer emp.) **Reviewed Date:** October 05, 2020 **What do you like best about pgAdmin?** And robust software, it has several features and functions for all types of databases. I use vectors, data manipulation, scripts, tables and more without having to use lines of code, directly connected to postgreSQL. PgAdmin provides a graphical interface that is easy to create a database. **What do you dislike about pgAdmin?** Creates incompatibility with outdated versions, needs the need to keep the most current version. It generated a little complexity in the installation, guaranteed support (free software) and because it is very robust it becomes a little heavy. **Recommendations to others considering pgAdmin:** I recommend pgAdmin where I found an easy software to create my database, with an easy and practical interface to execute my songs from my bank and with many functions that facilitate the interaction with postgreSQL and I already from the ready code line. **What problems is pgAdmin solving and how is that benefiting you?** With pgAdmin Create a database without having to make a line of code, with that it facilitated the difficulty of programming and many lines of code sequences, with its interface and connections with postgreSQL it was easy to create my database with several options of iterations and functions for my database. ### 33. A good database tool for PostgreSQL. **Rating:** 4.5/5.0 stars **Reviewed by:** Ranjith S. | Small-Business (50 or fewer emp.) **Reviewed Date:** August 29, 2020 **What do you like best about pgAdmin?** 1) Ease of use 2) Export to csv is very useful, I use it very often. 3) It has a very good gui 4) The schema and tables of database can be easily viewed from the tool 5) Its open source and free 6) Has good documentation and large community support 7) All administrative tools are available in the web gui 8) Allows import/export between multiple databases 9) Ease of installation 10) Creation of table, constraints directly from the gui **What do you dislike about pgAdmin?** 1) Cannot connect to amazon RDS due to a login compatibility issue 2) Crashes and at times uses too much of RAM 3) Not sure why they upgraded from pgAdmin 2 to pgAdmin 4 which is unstable and has a new layout. We all are habituated to version 2 of pgAdmin 4) Network has to be stable to work, it will not reconnect if you have any network issues. 5) To top it, if you looks your net, you will have to restart the complete application. **Recommendations to others considering pgAdmin:** If you are looking to manage postgres its the best tool **What problems is pgAdmin solving and how is that benefiting you?** We are using pgAdmin to connect to the postgres database on the server. Its the best out there for postgres, and I am able to analyze the schema and structure of the database with ease. Since it allows multiple connection, its easier to view all at one shot and compare if required. It serves the purpose of both DBA and developer. The main problem I have with pgAdmin is its stability while using unstable internet connection, otherwise hands-down its the best gui tool for postgres. ### 34. GUI provided allows to connect, disconnect, get query tool with ease of use. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** October 04, 2019 **What do you like best about pgAdmin?** The tools allow me to connect to a Postgres database with a good GUI, wherein I can see all database schema and can go down to different objects. One of the good features is to download the data result of a query in a CSV file, which I use quite frequently. **What do you dislike about pgAdmin?** 1. The search of an object from a list of objects, it is not allowed right now. If the search has to be made in these cases, we need to scroll the complete list which is not user-friendly approach at all. 2. The tabs at the top of the query area are not detachable which occupies a lot of space. 3. Backup and Restore of databases are not user-friendly, better to use cmd prompt for the same. **Recommendations to others considering pgAdmin:** Recommended. Easy to use and meets the requirement but there are few improvements areas which can be taken care easily. **What problems is pgAdmin solving and how is that benefiting you?** PGAdmin is a tool used in the organization for connecting the local database. The best part of the PGAdmin is, it allows us to connect the remote server database schemas. ### 35. Data Analyst Manager using pgAdmin **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** January 30, 2021 **What do you like best about pgAdmin?** I like how intuitive and easy to connect to tour DWH is, allowing to query your data by dragging the table’s name into the query’s tool. **What do you dislike about pgAdmin?** Sometimes, it take too long to query and it doesn’t show auto predicted column names. **What problems is pgAdmin solving and how is that benefiting you?** Currently, I use it to look for issues in our data when the reports don’t make sense. In that way, I can see in all the schemas. ### 36. Great User Experience **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** January 27, 2021 **What do you like best about pgAdmin?** The interface is quite user friendly and that is no charge **What do you dislike about pgAdmin?** sometime slow and sometime it needs more time to login **What problems is pgAdmin solving and how is that benefiting you?** create a Database with API Using API ### 37. Pg Admin review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Government Administration | Enterprise (> 1000 emp.) **Reviewed Date:** January 29, 2021 **What do you like best about pgAdmin?** See new geometries with the map viewer, options to commit or rollback **What do you dislike about pgAdmin?** Need of more auto populate SQL queries for example. The docking system still not working great. Perhaps implementation of the shapefile loader with pg Admin would be really great too **What problems is pgAdmin solving and how is that benefiting you?** Analytical Spatial problems with lots lg geospatial data. Pg Admin 4 is a great interface over code line to query the database ### 38. Great DB Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** June 30, 2020 **What do you like best about pgAdmin?** pgAdmin is one of the simplest db tools to use. The interface is nice and clean, it's easy to find how to add connections, query tables, and view statistics on a customizable dashboard. You can also create custom dashboard statistics which is great! **What do you dislike about pgAdmin?** It took some time to get setup running in our DC/OS cluster. Also, as far as I've found (I'm sure there's one if I read the user guide), there isn't an obvious keyboard shortcut (like ctrl/cmd + enter) to just run whatever query you're trying to test out - you have to click the run button. **What problems is pgAdmin solving and how is that benefiting you?** I use pgAdmin to debug what data is actually in my application's database vs what I think should be there based on actions taken in the application. I've also used it to debug connection issues, query slowness, and testing out new queries for addition to our API. ### 39. Simple to use. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Education Management | Small-Business (50 or fewer emp.) **Reviewed Date:** January 28, 2021 **What do you like best about pgAdmin?** Simple to use. Easy to download and integrate with other apps like Matlab. **What do you dislike about pgAdmin?** Only supports PostgreSQL. Look into support other items like MySQL **What problems is pgAdmin solving and how is that benefiting you?** Handling large data sets. Manipulating large data for further post processing ### 40. Simple yet highly effective **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Government Administration | Enterprise (> 1000 emp.) **Reviewed Date:** September 18, 2020 **What do you like best about pgAdmin?** It does everything that oracle and sql server can do just without the stupidly priced license fee. I use it on a AWS cloud DB and since starting to use it 6month ago I’m now looking to move away other DBs from oracle/sql server. **What do you dislike about pgAdmin?** Nothing really. At first it can seem complex as there is many settings. However in their default position they work well and without issue **What problems is pgAdmin solving and how is that benefiting you?** Saving £1000’s on oracle/sql server license. With hope to move over to this fully in next 2 years ### 41. Great tool to access your database quickly and increase productivity **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 18, 2020 **What do you like best about pgAdmin?** It provides multiple options to connect to your database server. It provides very good user interface to see all the related information. It also provides query suggestions which is a very good feature **What do you dislike about pgAdmin?** UI is little laggy the team should work on the UI improvements **Recommendations to others considering pgAdmin:** Great tool to access your database go for it!! **What problems is pgAdmin solving and how is that benefiting you?** It solves a problem of remote access ypur database. It gives very interactive way to query your database ### 42. The best Database Tool "pgAdmin" **Rating:** 4.5/5.0 stars **Reviewed by:** Amir K. | Software Engineer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** October 16, 2019 **What do you like best about pgAdmin?** It is a best Database Management Tool for me whenever i want to build a project i always choose pgAdmin for my database. Today my favourite Database Management Tool is pgAdmin. It is free. It is open source. It is available in more than a dozen languages. If you have a problem that you need help with, please make sure you check the pgAdmin documentation for a solution first. It is the best solution which documentation provides us. It has a large community which use pgAdmin so there is full support always available for you. So begin your backend work with pgAdmin. **What do you dislike about pgAdmin?** I don't think it has anything for which i would dislike it. As i know it is a best database management tool and i did not experience any problem while using it. But Among the things that I dislike about pgAdmin is that the new version of Pgadmin4, changed the location and structure of the tool panels and i am habitual of Pgadmin2. But it is not a big deal and i always prefer pgAdmin for my backend work. **Recommendations to others considering pgAdmin:** Guys use pgAdmin for your web or software work. It is free and open source. **What problems is pgAdmin solving and how is that benefiting you?** I use it to write and test queries. I use it to make functions which i use to explore different languages. I use it because is easy to use and manage. I use it to make APIs which i use at different platforms. I use it because it supports most using operating systems like windows, mac and linux. ### 43. Postges interface for queries **Rating:** 3.5/5.0 stars **Reviewed by:** Micaela L. | Back-end Developer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** October 10, 2019 **What do you like best about pgAdmin?** The interface makes it easy to query database. Also you can export your results into a csv file which is great to analyze data. **What do you dislike about pgAdmin?** Its is not the most intuitive interface when you are new to use it. In windows sometimes i have to stop the process and restart from my task manager because it looses connection and won't work till I restart it like this. **Recommendations to others considering pgAdmin:** Easy to make query and manage tables in databases. Recommended to people not familiar with shell/bash commands for databases. Iterface could be more user friendly, but once you get used to it its quite easy **What problems is pgAdmin solving and how is that benefiting you?** I use it to write and test queries, to look for possible bugs created for a faulty query. and analize data. I also use it when im learning new languages to create APIs. It is easy to manage, and I dont make complicated commands in bash. ### 44. PGAdmin makes easy to use it - postgres interface for querying **Rating:** 3.5/5.0 stars **Reviewed by:** Nikhil K. | I am a Sr. Software Engineer, 5 years of experience in development, use "whereby app" formely known as "Appear" very frequently for solving some of the issues by sharing with peers screen online., Small-Business (50 or fewer emp.) **Reviewed Date:** October 01, 2019 **What do you like best about pgAdmin?** Different options to get insert/Create/Update scripts of the table as well as taking backup of the table from the PGAdmin interface or directly exporting query result into csv file, which saves a lot of time and save query into file using save button. **What do you dislike about pgAdmin?** Tab Switching of the opened query tool , not allowed for windows users by using "Alt+ Tab" generally . So its difficult to switch between tabs therefore we need to use the mouse cursor , it takes time while coding. **What problems is pgAdmin solving and how is that benefiting you?** writing queries , functions and other objects and organize these objects under the certain schema of a Database , so that i can maximize the output by accessing the any object from the required database or schema and connect with server also. ### 45. Simple, but poor in advanced options **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** July 24, 2020 **What do you like best about pgAdmin?** Writing and executing queries, good for beginners in PostgreSQL **What do you dislike about pgAdmin?** Sometimes it crashes, poor with advanced options **Recommendations to others considering pgAdmin:** Its simple, relatively fast and serves the purpose (DDL and DML) **What problems is pgAdmin solving and how is that benefiting you?** Writing PostgreSql queries, creating tables, executing queries ### 46. Pgadmin Postgresql handling **Rating:** 4.0/5.0 stars **Reviewed by:** Carmen H. | Secretarial Assistant, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2019 **What do you like best about pgAdmin?** I love Pgadmin since it is an administrative tool for PostgreSQL, which allows you to complete all your administration tasks with ease such as: Easy to perform maintenance tasks of a Database where you can create and manage data tables, make copies security and restore, import and export data from one database to another, creating users, roles and privileges. The ease of installation is also ideal, it has a very intuitive interface and helps you get quick access to your external databases, something that would be tedious to do it through the Postgresql console. Finally, it offers great facility to audit the services of the Database, monitor the connected users. **What do you dislike about pgAdmin?** There are several details that cause me uneasiness from the security point, for example a user with a Query Role, can visualize the entire structure of the Database, indexes that make it up, and which are the users assigned to each Database , which is dangerous if any user tries to illegally access the Database with another type of Role. Another of the uncomfortable details is when a Database with a lower version is backed up under the .Backup format, and when being restored in a higher version it generates a problem preventing its restoration. Also the error messages are not very clear or descriptive for the non-administrator user, which tends to generate confusion **Recommendations to others considering pgAdmin:** I would recommend it to those organizations or companies that are administering one or several Databases through the Command Environment, since with the Pgadmin Graphical administrator it increases the productivity of its workers, reducing the time dedicated to a Database with respect to the Environment. of Console. I would also recommend it for those companies or people that start with a Database administrator in the Postgress language since it is a very friendly and easy-to-install tool for Windows and Linux systems, which is part of the Postgrsql DBA Day, for administration of an infrastructure database **What problems is pgAdmin solving and how is that benefiting you?** The main benefit from my point of view is that I currently manage and administer several databases which are physically located in different Database servers. With Pgadmin I can centralize all the Databases in a single graphic environment, where I can visualize it in the same set without having to change the console and make connections through command to other servers. With respect to the knowledge of Pgadmin, it presents a learning curve which is short and facilitates the training of analysts who need to enter the process of administering a database. In addition, this institute has a geographic information system and pgadmin facilitates the work of developers, since they have special plug-ins for this type of tasks ### 47. PG Admin review **Rating:** 4.0/5.0 stars **Reviewed by:** Priyabrata N. | Senior Cloud Architect, Enterprise (> 1000 emp.) **Reviewed Date:** November 07, 2019 **What do you like best about pgAdmin?** Its very easy to use and user friendly. Making connection is super easy. **What do you dislike about pgAdmin?** We cannot run multiple select statements at once. If we do very hard to diferentiate. Comparing the data between two tables or matching data is very difficult. **What problems is pgAdmin solving and how is that benefiting you?** Db related issues and DB management ### 48. Great tool but not the best **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 09, 2020 **What do you like best about pgAdmin?** I have been using pgAdmin for quite a long time, What I really like about this tool is, it is easy to use. Simple UI. **What do you dislike about pgAdmin?** The tool is very heavy, needs a little improvement. **What problems is pgAdmin solving and how is that benefiting you?** Easy to execute queries and great tool to view data inside table ### 49. Amazing tool for postgres database access **Rating:** 5.0/5.0 stars **Reviewed by:** Umair A. | Solution Architect, Enterprise (> 1000 emp.) **Reviewed Date:** November 11, 2019 **What do you like best about pgAdmin?** I like its simplicity to install on windows and access the database including local or remote.Further its citext feature is nice and prevent user to handle string in code. **What do you dislike about pgAdmin?** Its new user interface from pgadmin 4 is disturbed a bit. It hangs alot. **Recommendations to others considering pgAdmin:** It is the best tool to access and manage postgres database. **What problems is pgAdmin solving and how is that benefiting you?** Everyone in our team cant manage the database from command line so we decided to use this standard tool for postgres. ### 50. extremely simple tool for plSQL developers **Rating:** 4.5/5.0 stars **Reviewed by:** SUBHA P. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** May 10, 2019 **What do you like best about pgAdmin?** Pgadmin is a user interface for Postgresql servers where developers can execute queries It also has provision to create database,schema,tables,index,sequences etc It also gives option to take backup at database level,schema and table level with different compression options and restoring is pretty much simple Maintenance like vacuum,analyze could be done from this pgAdmin It always give hints on dead rows whenever maintenance needs to be done **What do you dislike about pgAdmin?** even when roles are restricted they will be able to view schemas and table structures ,only data will be invisible,but structure is always visible **What problems is pgAdmin solving and how is that benefiting you?** Designing an OLTP application for Geographical Information systems and the developers found so easy to code with the help of pgadmin. It directly connects to the Postgresql servers seamlessly ## pgAdmin Discussions - [Sql sheet](https://www.g2.com/discussions/sql-sheet) - 1 comment, 1 upvote - [View pgAdmin pricing details and edition comparison](https://www.g2.com/products/pgadmin/reviews?locale=it§ion=pricing&secure%5Bexpires_at%5D=2026-05-30+01%3A56%3A25+-0500&secure%5Bsession_id%5D=21148831-542b-459c-9ac8-3fe932256f59&secure%5Btoken%5D=2155bbd378c49210ae20c5fdbf4792179ebdc3d0c5b7c1c65253a10621cc4050&format=llm_user) ## pgAdmin Integrations - [IntelliJ IDEA](https://www.g2.com/products/intellij-idea/reviews) ## Top pgAdmin Alternatives - [AWS Cloud Development Kit (AWS CDK)](https://www.g2.com/products/aws-cloud-development-kit-aws-cdk/reviews) - 4.4/5.0 (127 reviews) - [AWS Schema Conversion Tool](https://www.g2.com/products/aws-schema-conversion-tool/reviews) - 4.3/5.0 (53 reviews) - [IBM Cloud Bare Metal Servers](https://www.g2.com/products/ibm-cloud-bare-metal-servers/reviews) - 4.0/5.0 (28 reviews)