> ## Documentation Index
> Fetch the complete documentation index at: https://docs.apinizer.com/llms.txt
> Use this file to discover all available pages before exploring further.
# DB-2-API: Select Usage
> Provides Select usage on DB-2-API in Apinizer Platform. You can perform data reading operations from the database and publish SQL SELECT queries as REST API endpoints.
To get more information about creating DB-2-API, [click here](/en/develop/api-proxy-creation/api-creator-db-api-creation).
## 1. Creating DB-2-API
An API Proxy that manages employee records is desired to be created.
The name and description fields of DB-2-API are filled and the **Save and Next** button is clicked.
**Visual containing DB-2-API settings is provided below:**
When DB-2-API is created, API and endpoint information is on the left panel, and definition information of the selected method is on the right side.
## 2. Creating Endpoint
Click the **Add** button to open the method/endpoint creation panel.
**Visual containing method creation settings is provided below:**
**Visual containing the message returned as test result is provided below:**
## 3. Viewing API Definition Documents
Click the **Show Specs** link to access the API definition files belonging to Employee Db-2-API.
**Visual containing Spec Information dialog is provided below:**
## 4. Creating API Proxy
An API Proxy can be created instantly by clicking the **Create API Proxy** button from the DB-2-API screen.
When creating the API Proxy, fill in the required fields shown in the visual below and click the **Save** button.
### 4.1 Going Live with API Proxy
Employee API Proxy can be quickly loaded onto the defined environment and opened for client consumption.
This operation can be managed through the dialog opened by clicking the **Deploy** button on the API Proxy screen.
## 5. Testing
When a request is sent to the **"getPersonByName" method** with the relevant parameter, the following response is returned.
