AppCorpus MCP gives your agent current app data, prices, screens, features and sources.
View JSON
GET /api/v3/apps/6781453187
{
"app_id": 6781453187,
"canonical_url": "https://appcorpus.com/apps/magicsql-sql-client-editor-6781453187",
"identity": {
"name": "MagicSQL - SQL Client & Editor",
"slug": "magicsql-sql-client-editor",
"developer": {
"name": "Fatih Yesilbas",
"url": "https://appcorpus.com/developers/fatih-yesilbas-developer_057e01bfa1a3d95b27036403f56d6c86"
},
"icon_url": "https://is1-ssl.mzstatic.com/image/thumb/Purple211/v4/cd/60/80/cd6080f9-2a0b-32f6-44b7-3d5090a74ed1/AppIcon-0-0-1x_U007epad-0-1-85-220.png/512x512bb.jpg",
"stores": [
"apple"
],
"platforms": [
"iphone",
"ipad"
],
"status": {
"state": "active",
"label": "Active",
"last_checked": "2026-08-07",
"last_checked_label": "7 Aug 2026",
"banner": null,
"region_note": null
}
},
"listings": [
{
"store": "apple",
"status": "ACTIVE",
"url": "https://apps.apple.com/us/app/magicsql-sql-client-editor/id6781453187?uo=4",
"rating": 0.0,
"rating_count": 0,
"formatted_price": "Free",
"is_free": true,
"has_iap": true,
"has_subscription": false,
"version": "1.0",
"updated": "2026-06-25",
"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",
"Utilities"
],
"appcorpus": [
{
"category_id": "developer-tools",
"label": "Developer tools",
"url": "https://appcorpus.com/categories/developer-tools"
},
{
"category_id": "utilities",
"label": "Utilities",
"url": "https://appcorpus.com/categories/utilities"
}
]
},
"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": "us",
"last_verified": "2026-08-07",
"rows": [
"MagicSQL Pro Lifetime — $3.99"
]
}
],
"screens": [
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/77/da/6a/77da6a0d-5126-d99f-8d2c-91fabfa60269/01_server_list.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 1"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/77/da/6a/77da6a0d-5126-d99f-8d2c-91fabfa60269/01_server_list.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 2"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/e3/58/b5/e358b562-724c-442c-555f-d9e7a859d370/02_data_grid.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 3"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/e3/58/b5/e358b562-724c-442c-555f-d9e7a859d370/02_data_grid.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 4"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/f4/0a/26/f40a26c5-8e53-5bfa-0459-a6a3ff1266e2/03_sql_editor.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 5"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/5a/85/6f/5a856f03-9ad1-1e7f-58b6-174bad8912bd/04_split_screen.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 6"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/f4/0a/26/f40a26c5-8e53-5bfa-0459-a6a3ff1266e2/03_sql_editor.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 7"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/5a/85/6f/5a856f03-9ad1-1e7f-58b6-174bad8912bd/04_split_screen.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 8"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/d7/3d/78/d73d7852-adbe-938d-d2a2-540e95afb52a/05_schema.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 9"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/06/ce/ee/06ceee9d-d731-77d4-bf1f-31c7b611dd08/06_structure.png/1600x1600bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 10"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/d7/3d/78/d73d7852-adbe-938d-d2a2-540e95afb52a/05_schema.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 11"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/06/ce/ee/06ceee9d-d731-77d4-bf1f-31c7b611dd08/06_structure.png/360x480bb.jpg",
"store": "apple",
"platform": "ipad",
"alt": "MagicSQL - SQL Client & Editor ipad screenshot 12"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/39/37/87/393787c1-588a-505b-3de3-6ebc96cff74d/01_server_list.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 13"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/f9/90/ef/f990ef39-ca96-a76e-7a3e-bc6f8adbb1b8/02_data_grid.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 14"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource211/v4/9b/21/8b/9b218b90-c026-9cbd-8fcf-cc4536730204/03_sql_editor.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 15"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/c5/2e/93/c52e93c3-bc60-2c4b-dc9e-9b19a32f41b3/04_split_screen.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 16"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/79/e9/10/79e910ac-b0ce-3b35-8797-8e6b0336f497/05_schema.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 17"
},
{
"url": "https://is1-ssl.mzstatic.com/image/thumb/PurpleSource221/v4/68/50/78/6850780f-6514-eeac-63da-95d52465eb90/06_structure.png/1284x1600bb.jpg",
"store": "apple",
"platform": "iphone",
"alt": "MagicSQL - SQL Client & Editor iphone screenshot 18"
}
],
"ratings": [
{
"store": "apple",
"average": 0.0,
"count": 0,
"market": "us",
"observed_at": "2026-08-07",
"reviews": []
}
],
"privacy": [
{
"store": "apple",
"declarations": [
{
"title": "Data Not Collected",
"detail": "",
"source": "Developer declared"
}
],
"accessibility": []
}
],
"changes": [
{
"store": "apple",
"version": "1.0",
"released_at": "2026-06-25",
"notes": ""
}
],
"alternatives": [
{
"app_id": 6756337188,
"name": "MySQL365",
"url": "https://appcorpus.com/apps/mysql365-6756337188",
"reason": "Same category + similar ratings"
},
{
"app_id": 6759742254,
"name": "Tablewright: PostgreSQL Editor",
"url": "https://appcorpus.com/apps/tablewright-postgresql-editor-6759742254",
"reason": "Same category + similar ratings"
},
{
"app_id": 6760155376,
"name": "PychampStudio",
"url": "https://appcorpus.com/apps/pychampstudio-6760155376",
"reason": "Same category + similar ratings"
},
{
"app_id": 6761461266,
"name": "Python Code App - IDE & Editor",
"url": "https://appcorpus.com/apps/python-code-app-ide-editor-6761461266",
"reason": "Same category + similar ratings"
},
{
"app_id": 6759238277,
"name": "Tablewright: SQLite Editor",
"url": "https://appcorpus.com/apps/tablewright-sqlite-editor-6759238277",
"reason": "Same category + similar ratings"
},
{
"app_id": 585637688,
"name": "python3$",
"url": "https://appcorpus.com/apps/python3-585637688",
"reason": "Same category + similar ratings"
}
],
"evidence_summary": {
"index_state": "S1",
"evidence_level": 1,
"level_label": "Live store listing",
"indexable": true,
"last_verified_at": "2026-08-07",
"unknown_fields": [
"Independent summary has not been published yet."
],
"sources": [
"App Store"
]
},
"availability_markets": {
"live": [
"us"
],
"selected": "us",
"note": null
},
"feature_events": {
"events": []
},
"features_slice": {
"plans": [
{
"code": "pro-lifetime",
"label": "MagicSQL Pro Lifetime",
"kind": "unknown",
"status": "store_listed",
"prices": [
{
"storefront": "us",
"formatted": "$3.99",
"billing_period": "one_time"
}
],
"trial": null
}
],
"features": [],
"unknown_features": [],
"data_cutoff": "7 Aug 2026"
}
}
