AppCorpus MCP gives your agent current app data, prices, screens, features and sources.
View JSON
GET /api/v3/apps/1233662353
{
"app_id": 1233662353,
"canonical_url": "https://appcorpus.com/apps/postgresql-client-1233662353",
"identity": {
"name": "PostgreSQL Client",
"slug": "postgresql-client",
"developer": {
"name": "Filippo Maguolo",
"url": "https://appcorpus.com/developers/filippo-maguolo-developer_969a0a27f63e0e53a376587a3ef26af9"
},
"icon_url": "https://is1-ssl.mzstatic.com/image/thumb/Purple221/v4/aa/e1/9a/aae19a06-fd09-2d4c-2116-3afa67a87d74/AppIcon-0-0-1x_U007epad-0-1-sRGB-85-220.png/512x512bb.jpg",
"stores": [
"apple"
],
"platforms": [
"iphone",
"ipad"
],
"status": {
"state": "active",
"label": "Active",
"last_checked": "2026-07-31",
"last_checked_label": "31 Jul 2026",
"banner": null,
"region_note": null
}
},
"listings": [
{
"store": "apple",
"status": "ACTIVE",
"url": "https://apps.apple.com/us/app/postgresql-client/id1233662353?uo=4",
"rating": 4.6,
"rating_count": 152,
"formatted_price": "Free",
"is_free": true,
"has_iap": true,
"has_subscription": false,
"version": "47.0",
"updated": "2026-07-31",
"currency": "USD"
}
],
"summary": {
"one_liner": null,
"summary": null,
"best_for": [],
"not_for": [],
"status": "fallback",
"at_a_glance": [
"Free to download",
"In-app purchases"
]
},
"categories": {
"official": [
"Developer Tools"
],
"appcorpus": [
{
"category_id": "developer-tools",
"label": "Developer tools",
"url": "https://appcorpus.com/categories/developer-tools"
}
]
},
"use_cases": [],
"features": [
{
"capability_id": "free_app",
"label": "Free app",
"availability": "yes",
"access_level": "free",
"scope": null,
"evidence": "Store published"
},
{
"capability_id": "in_app_purchases",
"label": "In-app purchases",
"availability": "yes",
"access_level": "free_limited",
"scope": null,
"evidence": "Store published"
}
],
"pricing": [
{
"store": "apple",
"formatted_price": "Free",
"is_free": true,
"has_iap": true,
"has_subscription": false,
"currency": "USD",
"market": "es",
"last_verified": "2026-07-31",
"rows": [
"Free to download",
"In-app purchases"
]
}
],
"screens": [
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/c9/2a/91/c92a9168-614e-1e20-16d9-0cd093108c03/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-06-24_at_11.53.34.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 1"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/99/e9/99/99e999ad-54f9-bd9d-0324-4d1096aacb53/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-06-24_at_11.56.09.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 2"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/35/98/b5/3598b516-fe49-c544-c443-d7711eb06eb0/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-06-24_at_12.00.02.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 3"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/0d/27/d2/0d27d22c-be5e-545e-a623-5dc2b76004b0/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-06-24_at_12.00.27.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 4"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/be/f6/8a/bef68a1c-6d73-4fe5-1181-50e51f6e11cc/e725ab4f-a572-4ff5-bcc2-0e6cd61c0920_Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2024-05-15_at_12.46.59.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 5"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/bc/52/9e/bc529e0e-03ed-0ee0-6157-f000fd682827/7b1a27b6-dabe-4283-b499-61f2c2a3b69e_Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2024-05-15_at_12.49.32.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 6"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/e7/8b/65/e78b65a8-ac03-df45-eb3f-dc884a2642aa/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-06-24_at_12.15.01.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 7"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/74/57/81/7457811f-85ed-b001-d589-1d56237f0529/Simulator_Screenshot_-_iPad_Pro_13-inch__U0028M4_U0029_-_2025-01-14_at_14.32.27.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "PostgreSQL Client ipad screenshot 8"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/d4/5b/0a/d45b0af5-c3b1-8a50-ed88-ac0e874de7f6/screen2.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 9"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/0f/67/71/0f677199-0179-2a91-2dd2-14c8b902326d/screen3.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 10"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/df/bb/45/dfbb454e-37b0-8daf-bcf4-504eb9577ab9/screen4.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 11"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/64/dd/be/64ddbead-c9d1-033c-63c8-99681a2af851/screen5.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 12"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/f5/0a/3b/f50a3b0e-b531-7fdb-794d-48fef6a1d0fb/screen6.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 13"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/34/4e/61/344e612b-1ede-181f-2197-6c89650c70cd/screen7.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 14"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/72/ec/fe/72ecfe35-5108-3a24-dde6-8c118d9ad1a1/screen8.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 15"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/17/33/5f/17335f5d-e69e-80b3-e451-a99f9b117cac/screen9.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 16"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/88/63/5b/88635b81-f7eb-bcbc-11ce-f5e84ea9ae67/screen10b.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 17"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/86/aa/bd/86aabd63-da20-1bd4-1ab9-f4572e8e0948/screen8_-_Postgres.png/1290x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "PostgreSQL Client iphone screenshot 18"
}
],
"ratings": [
{
"store": "apple",
"average": 4.6,
"count": 152,
"market": "es",
"observed_at": "2026-07-31",
"reviews": [
{
"rating": 5,
"title": "Yup",
"body": "It works, as others have mentioned it’s not “perfect” but it gets the job done when you need to access your databases on the go. Displays a form entry for your stored proc’s arguments too which is nifty! It’s all better than trying to manipulate psql through a terminal app on iOS thats for sure. And for a good price too.",
"author": "hallach",
"date": "31 Jul 2026"
},
{
"rating": 4,
"title": "Many imperfections; unbeatable price",
"body": "Look, for the price, you’re not going to do better. The competition have enterprise-level subscription rates. This app has a fantastic hobbyist-level price. And that’s what I am, so it’s the only viable option for iPad as far as I can see. It works. It runs queries. It connects and reconnects beautifully. I’ve been creating tables, inserting data, parsing tens of thousands of records without trouble. It crashes sometimes (but brings all your saved queries right back up). The interface can’t run an individual query, only everything that’s in the current window. The query and the results are in different “tabs” but you can’t switch from the query tab to the results tab without exiting the tab because of the keyboard-helper bar along the bottom (the one that’s still there even when you’re on a hardware keyboard). So it lacks polish, sure, but it’s WAY faster and easier than typing out the queries from the CLI. And again, check out that outstanding price!",
"author": "Tcabeen",
"date": "31 Jul 2026"
},
{
"rating": 5,
"title": "Very good. Redshift mostly works too",
"body": "Very good postgresql support. But I bought because it is one of the few solutions able to work with Redshift. Seems to support about 90%. Which is good enough for emergency support on the go. Hopefully this helps others.",
"author": "Missing my tabs",
"date": "31 Jul 2026"
},
{
"rating": 3,
"title": "Lots of bugs but good idea",
"body": "Until yesterday's update, time fields were incorrect. For example 13:30:00 would show 1:00 AM. That was fixed but now you cannot add a new record that has a date and time field. There are nice clocks and calendars but they will not actually fill in a field. I had to purchase another front end for anything more than viewing data.",
"author": "Isleofgough",
"date": "31 Jul 2026"
},
{
"rating": 2,
"title": "Good potential",
"body": "Great so far but a little buggy. For example, it’s impossible to create a chart. It just resets all fields when you finish anything. Edit: losing another start (3 to 2). Now it’s not connecting at all. I didn’t make any changes, the connection just errors now where other apps with the same login info work fine. I have to delete but would love to come back if it becomes more reliable.",
"author": "GilOsborne",
"date": "31 Jul 2026"
}
]
}
],
"privacy": [
{
"store": "apple",
"declarations": [
{
"title": "Data Not Collected",
"detail": "",
"source": "Developer declared"
}
],
"accessibility": []
}
],
"changes": [
{
"store": "apple",
"version": "30.1",
"released_at": null,
"notes": "• Fix database/schema switch"
},
{
"store": "apple",
"version": "31.0",
"released_at": null,
"notes": "• New Blob Hex Editor"
},
{
"store": "apple",
"version": "32.0",
"released_at": null,
"notes": "• New Connection list search and alphabetical sort option • \"Overview\" section UI updates and bug fixes"
},
{
"store": "apple",
"version": "33.0",
"released_at": null,
"notes": "• Fix Server Name Indication (SNI) in TLS connections"
},
{
"store": "apple",
"version": "34.0",
"released_at": null,
"notes": "• New user list view and privileges"
},
{
"store": "apple",
"version": "35.0",
"released_at": null,
"notes": "• Improved script results with new detailed panel • New filtering and sorting functionality in entity details • Accessibility fixes and improvements"
},
{
"store": "apple",
"version": "36.0",
"released_at": null,
"notes": "• New JS script (with integrated db connection and charts generator) • New manual grid data page navigation • Added support for FIDO Key in SSH tunnel • Bug fixes"
},
{
"store": "apple",
"version": "37.0",
"released_at": null,
"notes": "• New Grid Conditional Formatting • New Column Statistics • New regular expression search in data grid • CSV import improvements (with new date pattern conversion)"
},
{
"store": "apple",
"version": "38.0",
"released_at": null,
"notes": "• New table DDL generator • Improved CSV/NDJSON import with auto generated primary key • Improved SQL editor performance"
},
{
"store": "apple",
"version": "38.1",
"released_at": null,
"notes": "• Fix DDL table viewer • Fix SQL editor crash"
},
{
"store": "apple",
"version": "39.0",
"released_at": null,
"notes": "• New OpenAI integration"
},
{
"store": "apple",
"version": "39.1",
"released_at": null,
"notes": "• Stored procedures and functions call fixed"
},
{
"store": "apple",
"version": "40.0",
"released_at": null,
"notes": "• New Widgets with user defined charts • New named parameters in Shortcuts query execution"
},
{
"store": "apple",
"version": "40.1",
"released_at": null,
"notes": "• New Widgets with user defined charts • New named parameters for SQL in Shortcuts • Fix crashes"
},
{
"store": "apple",
"version": "40.2",
"released_at": null,
"notes": "• New Widgets with user defined charts • New named parameters for SQL in Shortcuts • Fix crashes"
},
{
"store": "apple",
"version": "41.0",
"released_at": null,
"notes": "• New multi-chat and multi-service A.I. integration • Additional Charts customizations"
},
{
"store": "apple",
"version": "41.1",
"released_at": null,
"notes": "• Added display of received notifications • Fixed SASL authentication in case of TLS certificate RSA-PSS"
},
{
"store": "apple",
"version": "41.2",
"released_at": null,
"notes": "• Bugs fixed in A.I. integration"
},
{
"store": "apple",
"version": "42.0",
"released_at": null,
"notes": "• New name for scripts (which can be referenced in Shortcuts) • New Global Search that allows a text search in the whole database • New SQL script results available through a faster (configurable) popup • Record View window can now navigate to multiple foreign key relation levels • New menu and UI reorganization"
},
{
"store": "apple",
"version": "43.0",
"released_at": null,
"notes": "• Added new match types in Global Search • Added match types in grid filter • Fixed scripts synchronization"
}
],
"alternatives": [
{
"app_id": 6737447574,
"name": "XML Viewer & XML Editor",
"url": "https://appcorpus.com/apps/xml-viewer-xml-editor-6737447574",
"reason": "Same category + similar ratings"
}
],
"evidence_summary": {
"index_state": "S1",
"evidence_level": 1,
"level_label": "Live store listing",
"indexable": true,
"last_verified_at": "2026-07-31",
"unknown_fields": [
"Independent summary has not been published yet."
],
"sources": [
"App Store"
]
},
"availability_markets": {
"live": [
"us"
],
"selected": "es",
"note": "No LIVE observation for ES yet."
},
"feature_events": {
"events": []
},
"features_slice": {
"plans": [],
"features": [],
"unknown_features": [],
"data_cutoff": "31 Jul 2026"
}
}
