A lightweight and deployment-friendly API gateway for making direct SQL queries to PostgreSQL and MSSQL databases. Designed for fast prototyping and data exchange, it simplifies API creation for database-driven applications without complex backend logic. Key Features:
📡 Instant API – Generate database-backed APIs in minutes.
⚡ Fast & Simple – Execute SQL queries with minimal setup.
🔄 JSON Responses – Returns structured, consistent JSON outputs.
🔗 Multi-Platform Use – Ideal for web, mobile, and desktop apps.
🛠 Perfect for Prototyping – Quickly test database interactions without a full backend.
Whether you're building an MVP, testing data integrations, or need a simple interface for accessing your database, Database Gateway API delivers a hassle-free solution! 🚀
API for making direct sql requests to a MSSQL or Postgresql dataabses It used to make an API for PostgreSQL or MSSQL databases for fast deploying simple db-related API's for checking the data (like firebase) Being silly and easy it provides fast queries to database and correct json responses, and it's still used for simple prototyping and data exchange for easy and on-testing web, mobile, desktop apps.
Request for Select query
| url | method |
|---|---|
| 127.0.0.1:8000/api/v1/make-db-request | POST |
{
"query_string": "select * from tbl_mg_materials",
"base64_columns": [ "group_code", "image_pict", "firm_id_guid"]
//"query_string": "select \"ResName\" from tbl_dk_resource",
}base64_columns - are the ones you prefer to be encoded in base64. You need it mostly in image BLOB
Response
{
"data": [
{
"T_ID": 1,
"a_status_id": 1,
"acc_card_cost_of_sale_id": 108,
"acc_card_inventory_id": 237,
"acc_card_purches_disc_id": 0,
"acc_card_purches_id": 0,
"acc_card_purches_ret_id": 0,
"acc_card_sale_disc_id": 36,
"acc_card_sale_id": 34,
"acc_card_sale_ret_id": 35,
"acc_card_scrap_id": 64,
"acc_card_usage_id": 64,
"data_send": 0,
"dept_id": 1,
"div_id": 1,
"firm_id": 1,
"firm_id_guid": "CAB9C297-C332-4BF1-AD3B-A27154BEEC7C",
"group_code": "SALAT",
"m_cat_id": 14,
"mat_auto_price": "0.00000",
"mat_auto_production": 0,
"mat_brand_code": "",
"mat_height": "0.00000",
"mat_last_purch_arap_id": 0,
"mat_length": "0.00000",
"mat_manufacturer": null,
"mat_name_lang1": "WINIGRET ",
"mat_name_lang2": "",
"mat_name_lang3": "",
"mat_name_lang4": "",
"mat_name_lang5": "",
"mat_online_isvisible": null,
"mat_real_price": "0.00000",
"mat_shop_code": "",
"mat_size_code": "",
"mat_weight": "0.00000",
"mat_width": "0.00000",
"material_code": "AN00000049",
"material_description": "",
"material_description1": "",
"material_id": 49,
"material_id_guid": "d0d43809-d242-43b0-acf7-0e4812bb2e94",
"material_name": "WINIGRET ",
"modify_date": "2021-03-18T16:00:33.523Z",
"security_code": "KUHNYA",
"spe_code": "",
"spe_code1": "",
"spe_code10": "",
"spe_code11": "",
"spe_code12": "",
"spe_code13": null,
"spe_code14": null,
"spe_code15": null,
"spe_code2": "",
"spe_code3": "",
"spe_code4": "",
"spe_code5": "",
"spe_code6": "",
"spe_code7": "",
"spe_code8": "",
"spe_code9": "",
"sync_datetime": null,
"unit_det_id": 1,
"unit_id": 1
},
{
"T_ID": 1,
"a_status_id": 1,
"acc_card_cost_of_sale_id": 108,
"acc_card_inventory_id": 237,
"acc_card_purches_disc_id": 0,
"acc_card_purches_id": 0,
"acc_card_purches_ret_id": 0,
"acc_card_sale_disc_id": 36,
"acc_card_sale_id": 34,
"acc_card_sale_ret_id": 35,
"acc_card_scrap_id": 64,
"acc_card_usage_id": 64,
"data_send": 0,
"dept_id": 1,
"div_id": 1,
"firm_id": 1,
"firm_id_guid": "CAB9C297-C332-4BF1-AD3B-A27154BEEC7C",
"group_code": "SALAT",
"m_cat_id": 14,
"mat_auto_price": "0.00000",
"mat_auto_production": 0,
"mat_brand_code": "",
"mat_height": "0.00000",
"mat_last_purch_arap_id": 0,
"mat_length": "0.00000",
"mat_manufacturer": null,
"mat_name_lang1": "OLWIYE ",
"mat_name_lang2": "",
"mat_name_lang3": "",
"mat_name_lang4": "",
"mat_name_lang5": "",
"mat_online_isvisible": null,
"mat_real_price": "0.00000",
"mat_shop_code": "",
"mat_size_code": "",
"mat_weight": "0.00000",
"mat_width": "0.00000",
"material_code": "AN00000050",
"material_description": "",
"material_description1": "",
"material_id": 50,
"material_id_guid": "CCC697DF-142B-449F-BF40-59C22C02E4CC",
"material_name": "OLWIYE ",
"modify_date": "2021-03-18T16:00:33.523Z",
"security_code": "KUHNYA",
"spe_code": "",
"spe_code1": "",
"spe_code10": "",
"spe_code11": "",
"spe_code12": "",
"spe_code13": null,
"spe_code14": null,
"spe_code15": null,
"spe_code2": "",
"spe_code3": "",
"spe_code4": "",
"spe_code5": "",
"spe_code6": "",
"spe_code7": "",
"spe_code8": "",
"spe_code9": "",
"sync_datetime": null,
"unit_det_id": 1,
"unit_id": 1
}
],
"status": 1,
"total": 2,
"message": "db query result"
}Request for Update | Insert | Delete query
| url | method |
|---|---|
| 127.0.0.1:8000/api/v1/make-db-request?executeOnly=1 | POST |
{
"query_string": "update tbl_dk_users set \"URegNo\" = 'SSFK123' where \"UId\" = 1"
}Response
{
"data": null,
"status": 1,
"total": 1,
"message": "db query result"
}!! Use executeOnly to make other than SELECT queries