# Execute SQL | Parsium Docs

Source: https://docs.parseium.com/api/operations/querydatabase/

# Execute SQL

POST

/v1/databases/{name}/query

Costs 1 credit. Accepts one SQL statement with positional args. Execution is capped at 10 seconds and responses at 500 rows / 256 KB.

## Authorizations

 Section titled “Authorizations ”

- **[apiKeyHeader](/api/#apikeyheader)**
- **[apiKeyQuery](/api/#apikeyquery)**

## Parameters

 Section titled “
Parameters
”

### Path Parameters

 Section titled “Path Parameters ”

 name

required

 string

Database name

## Request Body
required

 Section titled “Request Body
required
 ”

 Select media type application/json

 object

 sql

required

 string

 args

 Array

## Responses

 Section titled “
Responses
”

### 200

 Section titled “200 ”

Query result.

 Select media type application/json

 object

 columns

 Array<string>

 rows

 Array<Array>

 row_count

 integer

 truncated

 boolean

 ms

 integer

#### Headers

 Section titled “Headers ”

 X-Credits-Used

 integer

Credits consumed.

 X-Credits-Remaining

 integer

Remaining credit balance.

### 400

 Section titled “400 ”

Malformed request.

 Select media type application/json

 object

 error

required

 string

##### Example

```
invalid request
```

 field

Field that failed validation.

 string

 detail

 string

 hint

 string

### 401

 Section titled “401 ”

Missing or invalid API key.

 Select media type application/json

 object

 error

required

 string

##### Example

```
invalid request
```

 field

Field that failed validation.

 string

 detail

 string

 hint

 string

### 402

 Section titled “402 ”

Insufficient unreserved credits.

 Select media type application/json

 object

 error

required

 string

##### Example

```
insufficient credits
```

 required

required

 integer

 available

required

 integer

### 404

 Section titled “404 ”

Resource missing or not owned by this account.

 Select media type application/json

 object

 error

required

 string

##### Example

```
invalid request
```

 field

Field that failed validation.

 string

 detail

 string

 hint

 string

### 422

 Section titled “422 ”

Validation failed.

 Select media type application/json

 object

 error

required

 string

##### Example

```
invalid request
```

 field

Field that failed validation.

 string

 detail

 string

 hint

 string

### 503

 Section titled “503 ”

Feature or backing service is unavailable.

 Select media type application/json

 object

 error

required

 string

##### Example

```
invalid request
```

 field

Field that failed validation.

 string

 detail

 string

 hint

 string