Tool test API that connects to SQL server

Do we have a tool available that can connect to a database and base on a query he create request? I need it to create some tests based on some flags which are placed in the database.

I know that i can mock but i want to use real data from DEV, QA or UAT environment.

Example:

Let's say that i have an interface article with the following URL:

http://testserver:1234/api/articles/{articleID}

We have different types of articles in the database:

1. weight articles
2. piece articles

In the database we have table ARTICLES which have 3 columns: Id ,Name, IsWeight

I want to have a tool that base on a select from the database:

select top 1 Id from ARTICLES where IsWeight = false

lets say that the select returns 1

and base on this i want to have a get request:

http://testserver:1234/api/articles/1

And to check at least that the request returns 200.