🚀 Test & Automate Your SQLite APIs with Postman + dBaseServerless! 🌐
\nAre you a developer looking for an easy way to interact with SQLite using REST API? Meet dBaseServerless, the lightweight solution for database management!
\n💡 Why use Postman with dBaseServerless?
✅ Simplify API requests with a ready-to-use collection
✅ Test CRUD operations seamlessly
✅ Automate repetitive database tasks
✅ Debug & monitor API responses efficiently
⚡ How to Get Started:
1️⃣ Import the dBaseServerless API Collection into Postman
2️⃣ Set up base URLs for endpoints like Create, Read, Update, Delete
3️⃣ Make requests & analyze responses instantly!
Ready to simplify your SQLite API workflow? Try it now: dbaseserverless.iquipedigital.com 🚀
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"5447717","collectionId":"1b95438c-aba2-4cdb-9a24-39be7bbcffbb","publishedId":"2sB2qZF2oz","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2025-05-21T09:04:53.000Z"},"item":[{"name":"Tables","item":[{"name":"Create a Table","id":"d5288823-43f5-4079-a50e-6450e8ccefe7","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"create_table\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"columns\": [\r\n { \"name\": \"id\", \"type\": \"INTEGER\", \"constraints\": \"PRIMARY KEY AUTOINCREMENT\" },\r\n { \"name\": \"name\", \"type\": \"TEXT\", \"constraints\": \"NOT NULL\" },\r\n { \"name\": \"department\", \"type\": \"TEXT\" },\r\n { \"name\": \"salary\", \"type\": \"REAL\" },\r\n { \"name\": \"hire_date\", \"type\": \"TEXT\" }\r\n ]\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"d5288823-43f5-4079-a50e-6450e8ccefe7"},{"name":"List All Tables and their Fields","id":"edf5f561-e86e-41ff-b8ee-480d80c6f092","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"list_tables\",\r\n \"payload\": {}\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"edf5f561-e86e-41ff-b8ee-480d80c6f092"},{"name":"Backup the Database","id":"60361c9f-1612-4b5f-85ef-04ddc9bff15c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"backup_database\",\r\n \"payload\": {}\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"60361c9f-1612-4b5f-85ef-04ddc9bff15c"},{"name":"Delete Table","id":"5cfc50ba-945d-4d83-bce2-af2929fc1980","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"delete_table\",\r\n \"payload\": {\r\n \"tableName\": \"employees\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"5cfc50ba-945d-4d83-bce2-af2929fc1980"},{"name":"Delete a Record (if any are left, e.g., Alice)","id":"710093d5-ce13-4f7f-9d33-54179faf7ba8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"delete_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"where\": [\r\n {\r\n \"field\": \"name\",\r\n \"operator\": \"=\",\r\n \"value\": \"Alice Wonderland\"\r\n }\r\n ]\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"710093d5-ce13-4f7f-9d33-54179faf7ba8"}],"id":"ff871e02-a7c2-43e7-baec-468cd4ec5fd3","_postman_id":"ff871e02-a7c2-43e7-baec-468cd4ec5fd3","description":""},{"name":"Database","item":[{"name":"Create Database","id":"3c72c452-38fa-4770-b643-88cdc4a9e6b4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"action\": \"create_database\",\r\n \"payload\": {\r\n \"dbName\": \"book_data\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"3c72c452-38fa-4770-b643-88cdc4a9e6b4"},{"name":"Delete Database","id":"8a92fbe4-acc9-40e6-9b2a-047c44aba067","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"action\": \"delete_database\",\r\n \"payload\": {\r\n \"dbName\": \"company_data\"\r\n }\r\n }","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"8a92fbe4-acc9-40e6-9b2a-047c44aba067"},{"name":"Backup the Database (Recap)","id":"227c6191-e231-4d56-98b5-0013b1e3d5d4","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data_backup_20250520170631.sqlite\",\r\n \"action\": \"backup_database\",\r\n \"payload\": {}\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"227c6191-e231-4d56-98b5-0013b1e3d5d4"},{"name":"(Optional but good for demo) Delete the Original Database to show restore works:","id":"b65cee2a-8c42-430e-a900-d5a0a4eca8a9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"action\": \"delete_database\",\r\n \"payload\": {\r\n \"dbName\": \"company_data\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"b65cee2a-8c42-430e-a900-d5a0a4eca8a9"},{"name":"Restore the Database","id":"b0fa842a-0dca-4f41-acd4-b1557c19e500","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"action\": \"restore_database\",\r\n \"payload\": {\r\n \"dbNameToRestore\": \"company_data\",\r\n \"backupFileName\": \"company_data_backup_20231027101530.sqlite\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"b0fa842a-0dca-4f41-acd4-b1557c19e500"},{"name":"Verify the Restored Database Content","id":"b6b2f4ad-f6e2-4b8c-89dc-4eac7e8bddf8","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"select_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"b6b2f4ad-f6e2-4b8c-89dc-4eac7e8bddf8"}],"id":"fd8a1d4f-6efa-4c8d-970a-fb707fcea4db","_postman_id":"fd8a1d4f-6efa-4c8d-970a-fb707fcea4db","description":""},{"name":"Records","item":[{"name":"Insert Records into","id":"67b9611f-921f-415d-ab5a-45daf48d4799","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"insert_record\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"data\": {\r\n \"name\": \"Alice Wonderland\",\r\n \"department\": \"Engineering\",\r\n \"salary\": 75000.00,\r\n \"hire_date\": \"2022-01-15\"\r\n }\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"67b9611f-921f-415d-ab5a-45daf48d4799"},{"name":"Select Records","id":"63d2bdb4-a066-4de4-90d6-ad8a502315b2","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"select_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"63d2bdb4-a066-4de4-90d6-ad8a502315b2"},{"name":"Select Records with Filters, Sorting, and Specific Fields","id":"eeb23626-7390-4d58-9d2c-685d635b8a1b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"select_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"criteria\": {\r\n \"fields\": [\r\n \"name\",\r\n \"salary\"\r\n ],\r\n \"where\": [\r\n {\r\n \"field\": \"department\",\r\n \"operator\": \"=\",\r\n \"value\": \"Engineering\"\r\n }\r\n ],\r\n \"orderBy\": [\r\n {\r\n \"field\": \"salary\",\r\n \"direction\": \"DESC\"\r\n }\r\n ]\r\n }\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"eeb23626-7390-4d58-9d2c-685d635b8a1b"},{"name":"Update a Record","id":"3b0c907f-0c1e-4481-af77-5796b4890014","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"update_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"data\": {\r\n \"salary\": 78000.00\r\n },\r\n \"where\": [\r\n { \"field\": \"name\", \"operator\": \"=\", \"value\": \"Alice Wonderland\" }\r\n ]\r\n }\r\n }","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"3b0c907f-0c1e-4481-af77-5796b4890014"},{"name":"Delete a Record","id":"178e1a2e-ff3f-499b-8f10-08455ed789be","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"dbName\": \"company_data\",\r\n \"action\": \"delete_records\",\r\n \"payload\": {\r\n \"tableName\": \"employees\",\r\n \"where\": [\r\n {\r\n \"field\": \"name\",\r\n \"operator\": \"=\",\r\n \"value\": \"Charlie Brown\"\r\n }\r\n ]\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"https://dbaseserverless.iquipedigital.com/v1/","urlObject":{"protocol":"https","path":["v1",""],"host":["dbaseserverless","iquipedigital","com"],"query":[],"variable":[]}},"response":[],"_postman_id":"178e1a2e-ff3f-499b-8f10-08455ed789be"}],"id":"602cf4f4-9aad-4671-abff-5a4fbd451188","_postman_id":"602cf4f4-9aad-4671-abff-5a4fbd451188","description":""}],"event":[{"listen":"prerequest","script":{"id":"9c578df5-3ed2-4352-bf47-c98fa1a92c3a","type":"text/javascript","packages":{},"exec":[""]}},{"listen":"test","script":{"id":"491c1a7e-1dad-4fc6-a9f7-861a4e39d79c","type":"text/javascript","packages":{},"exec":[""]}}],"variable":[{"key":"url","value":"https://dbaseserverless.iquipedigital.com/v1/","type":"string"}]}