# Connecting a database to Postman

**URL:** <https://community.postman.com/t/connecting-a-database-to-postman/20636>\
**Category:** Help Hub\
**Tags:** database\
**Created:** [February 21, 2021, 8:38pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636 "2021-02-21T20:38:40Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![nesrinej](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nesrinej](https://community.postman.com/u/nesrinej)\
**Post date:** [February 21, 2021, 8:38pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/1 "2021-02-21T20:38:40Z")

</div>

Hello All,  
How can i connect SQL developer to Postman?  
Please help me!

---

<div class="post-metadata">

**Author:** ![danny-dainton](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/danny-dainton/32/29401_2.png) [@danny-dainton](https://community.postman.com/u/danny-dainton)\
**Post date:** [February 22, 2021, 8:09am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/2 "2021-02-22T08:09:10Z")

</div>

Hey @nesrinej

You can’t directly connect Postman to a database, useless it has a set of HTTP endpoints that you can use to see/edit the data in the tables.

---

<div class="post-metadata">

**Author:** ![nesrinej](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nesrinej](https://community.postman.com/u/nesrinej)\
**Post date:** [February 22, 2021, 8:16am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/3 "2021-02-22T08:16:52Z")

</div>

Hello @danny-dainton  
Thanks for the response,  
Could you please tell me how can i edit my database from Postman ?  
Best regards,  
Nesrine

---

<div class="post-metadata">

**Author:** ![danny-dainton](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/danny-dainton/32/29401_2.png) [@danny-dainton](https://community.postman.com/u/danny-dainton)\
**Post date:** [February 22, 2021, 8:40am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/4 "2021-02-22T08:40:35Z")

</div>

Does your database have an API that you can interact with?

---

<div class="post-metadata">

**Author:** ![bpricilla](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/bpricilla/32/6511_2.png) [@bpricilla](https://community.postman.com/u/bpricilla)\
**Post date:** [February 22, 2021, 9:16am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/5 "2021-02-22T09:16:15Z")

</div>

For SQL developer I found this [link](https://www.oracle.com/database/technologies/appdev/rest.html)

Not sure you have referred this already 🙂 Got this from [this](https://community.postman.com/t/postman-and-database/706) similar topic.

So here based on the documentation you need to create your requests in Postman. Which in turn will help you for read/write into your Database. Also you can check if there’s some existing collection of requests for Oracle database.

---

<div class="post-metadata">

**Author:** ![murdoc.trammell](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@murdoc.trammell](https://community.postman.com/u/murdoc.trammell)\
**Post date:** [February 24, 2021, 3:47pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/6 "2021-02-24T15:47:23Z")

</div>

There are collections for SQL DB connection in Postman.

Can you provide a bit more context on why you need a RESTful API service to connect to a Database? It’s not exactly the right tool for the job.

---

<div class="post-metadata">

**Author:** ![nesrinej](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nesrinej](https://community.postman.com/u/nesrinej)\
**Post date:** [March 2, 2021, 8:33am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/7 "2021-03-02T08:33:30Z")

</div>

Hi @danny-dainton  
I would like to return the work that I’ve already done using SOAPUI with Postman.  
With SOAPUI, I can make JDBC requests. but I don’t know how to do that with Postman.  
Could you help me please !

---

<div class="post-metadata">

**Author:** ![nesrinej](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nesrinej](https://community.postman.com/u/nesrinej)\
**Post date:** [March 2, 2021, 8:39am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/8 "2021-03-02T08:39:34Z")

</div>

I would like to return the work that I’ve already done using SOAPUI with Postman.  
With SOAPUI, I can make JDBC requests. but I don’t know how to do that with Postman.  
Could you help me please !

---

<div class="post-metadata">

**Author:** ![danny-dainton](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/danny-dainton/32/29401_2.png) [@danny-dainton](https://community.postman.com/u/danny-dainton)\
**Post date:** [March 2, 2021, 9:25am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/9 "2021-03-02T09:25:52Z")

</div>

I don’t know anything about SOAPUI, they are 2 different applications with 2 different feature sets.

It looks like SOAPUI connects directly to a DB, Postman doesn’t do that.

[https://support.smartbear.com/readyapi/docs/functional/steps/jdbc-request.html](https://support.smartbear.com/readyapi/docs/functional/steps/jdbc-request.html)

If the DB has an API that you can interact with then you _could_ send requests to it and add/read/remove data from the tables but if it hasn’t, you won’t be able to.

Postman isn’t a database testing tool so anything to get it to interact with a database would just be a workaround.

---

<div class="post-metadata">

**Author:** ![nesrinej](https://avatars.discourse-cdn.com/v4/letter/n/54ee81/32.png) [@nesrinej](https://community.postman.com/u/nesrinej)\
**Post date:** [March 2, 2021, 1:01pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/10 "2021-03-02T13:01:48Z")

</div>

thanks for your replay @danny-dainton .  
I use SQL Developer , but my REST Services menu not show up in SQL Developer ☹

---

<div class="post-metadata">

**Author:** ![murdoc.trammell](https://avatars.discourse-cdn.com/v4/letter/m/5e9695/32.png) [@murdoc.trammell](https://community.postman.com/u/murdoc.trammell)\
**Post date:** [March 2, 2021, 7:56pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/11 "2021-03-02T19:56:33Z")

</div>

Some links that might help you:

> **[Databases](https://documenter.getpostman.com/view/5922408/RznJmGfn?version=latest)**
>
> This collection exists to show you how you can connect to some popular database options through Postman. Typically databases don't offer any form of REST API by default, so you'll need a little bit of extra tooling to get things going - covered...

[https://drill.apache.org/docs/use-postman-to-run-sql-queries-on-drill-data-sources/](https://drill.apache.org/docs/use-postman-to-run-sql-queries-on-drill-data-sources/)

---

<div class="post-metadata">

**Author:** ![manami1](https://avatars.discourse-cdn.com/v4/letter/m/ea5d25/32.png) [@manami1](https://community.postman.com/u/manami1)\
**Post date:** [February 4, 2022, 1:18am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/12 "2022-02-04T01:18:02Z")

</div>

has anyone tried this solution ?

---

<div class="post-metadata">

**Author:** ![sseenivasan89](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/sseenivasan89/32/8350_2.png) [@sseenivasan89](https://community.postman.com/u/sseenivasan89)\
**Post date:** [August 16, 2023, 1:05pm UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/13 "2023-08-16T13:05:03Z")

</div>

Hi  
i have tried connecting the postman to PostgreSQL database

[![](https://img.youtube.com/vi/EjDeNiCWNHA/maxresdefault.jpg "Connect Postman to PostgreSQL Database | Postman and Database | PostgreSQL and PostgREST") ](https://www.youtube.com/watch?v=EjDeNiCWNHA)

---

<div class="post-metadata">

**Author:** ![joystickpostman](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/joystickpostman/32/16600_2.png) [@joystickpostman](https://community.postman.com/u/joystickpostman)\
**Post date:** [August 20, 2023, 8:46am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/14 "2023-08-20T08:46:18Z")

</div>

We tried a few solutions to connect Postman and a database, but they were clunky. We wrote a small solution for this that can hit an API, validate the response, then validate against a database (postgreSQL or mySQL). Light-weight and easy to use. Open source, hopefully this is helpful to everyone.  
Check it out here: [https://github.com/getjoystick/witcher](https://github.com/getjoystick/witcher)

---

<div class="post-metadata">

**Author:** ![michaelderekjones](https://sea2.discourse-cdn.com/getpostman/user_avatar/community.postman.com/michaelderekjones/32/14819_2.png) [@michaelderekjones](https://community.postman.com/u/michaelderekjones)\
**Post date:** [August 21, 2023, 11:02am UTC](https://community.postman.com/t/connecting-a-database-to-postman/20636/15 "2023-08-21T11:02:28Z")

</div>

PostgreSQL and mySQL have API access, so it shouldn’t really be that difficult to implement.

Another method is to use Microsoft Flow or Logic Apps which allows you to utilise the connectors they have and surface it with a REST API. This removes a lot of the complexity in relation to authentication. For most of the databases that have connectors, they usually have their own API’s though.

I recommend discussing this with your development team. Get them to store the queries that you want in the database (which should ideally match with the queries that the front end uses).

Call those queries through the API.

This way you can mimic the flow that the front end app uses, using the same calls and queries.
