> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.labric.co/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.labric.co/_mcp/server.

# Execute Sql

POST https://platform.labric.co/api/v1/tools/query
Content-Type: application/json

Execute a read-only SQL query.

Runs the query against the organization's read replica, so it cannot
mutate data. Only SELECT statements are accepted. Supports positional
parameters via a params list. Use the schema tool to discover tables
first, and reference each column by its sql_column_name — foreign keys
carry an _id suffix in SQL (e.g. a 'sample' reference is the 'sample_id'
column).

Reference: https://docs.labric.co/api-reference/labric-api/tools/execute-sql

## OpenAPI Specification

```yaml
openapi: 3.1.0
info:
  title: openapi-tools
  version: 1.0.0
paths:
  /api/v1/tools/query:
    post:
      operationId: execute_sql
      summary: Execute Sql
      description: |-
        Execute a read-only SQL query.

        Runs the query against the organization's read replica, so it cannot
        mutate data. Only SELECT statements are accepted. Supports positional
        parameters via a params list. Use the schema tool to discover tables
        first, and reference each column by its sql_column_name — foreign keys
        carry an _id suffix in SQL (e.g. a 'sample' reference is the 'sample_id'
        column).
      tags:
        - tools
      parameters:
        - name: Authorization
          in: header
          description: Bearer authentication
          required: true
          schema:
            type: string
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/QueryResult'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
        '401':
          description: Unauthorized
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
        '403':
          description: Forbidden
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
        '404':
          description: Not Found
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
        '422':
          description: Unprocessable Content
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ValidationErrorSchema'
        '500':
          description: Internal Server Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
        '503':
          description: Service Unavailable
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorSchema'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/QueryBody'
servers:
  - url: https://platform.labric.co
    description: https://platform.labric.co
components:
  schemas:
    QueryBody:
      type: object
      properties:
        query:
          type: string
        params:
          type:
            - array
            - 'null'
          items:
            description: Any type
      required:
        - query
      title: QueryBody
    QueryResult:
      type: object
      properties:
        columns:
          type: array
          items:
            type: string
        data:
          type: array
          items:
            type: array
            items:
              description: Any type
      required:
        - columns
        - data
      title: QueryResult
    ErrorSchema:
      type: object
      properties:
        detail:
          type: string
      required:
        - detail
      title: ErrorSchema
    ValidationErrorSchema:
      type: object
      properties:
        detail:
          type: array
          items:
            type: object
            additionalProperties:
              description: Any type
      required:
        - detail
      description: Shape of Ninja's built-in 422 request-validation error response.
      title: ValidationErrorSchema
  securitySchemes:
    ApiKeyAuth:
      type: http
      scheme: bearer

```

## Examples



**Request**

```json
{
  "query": "SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5"
}
```

**Response**

```json
{
  "columns": [
    "id",
    "username",
    "email"
  ],
  "data": [
    [
      101,
      "jdoe",
      "jdoe@example.com"
    ],
    [
      102,
      "asmith",
      "asmith@example.com"
    ],
    [
      103,
      "mbrown",
      "mbrown@example.com"
    ],
    [
      104,
      "ljones",
      "ljones@example.com"
    ],
    [
      105,
      "kwilson",
      "kwilson@example.com"
    ]
  ]
}
```

**SDK Code**

```python
import requests

url = "https://platform.labric.co/api/v1/tools/query"

payload = { "query": "SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5" }
headers = {
    "Authorization": "Bearer <api_key>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.json())
```

```javascript
const url = 'https://platform.labric.co/api/v1/tools/query';
const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <api_key>', 'Content-Type': 'application/json'},
  body: '{"query":"SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5"}'
};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}
```

```go
package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://platform.labric.co/api/v1/tools/query"

	payload := strings.NewReader("{\n  \"query\": \"SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5\"\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <api_key>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://platform.labric.co/api/v1/tools/query")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <api_key>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"query\": \"SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5\"\n}"

response = http.request(request)
puts response.read_body
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.post("https://platform.labric.co/api/v1/tools/query")
  .header("Authorization", "Bearer <api_key>")
  .header("Content-Type", "application/json")
  .body("{\n  \"query\": \"SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5\"\n}")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('POST', 'https://platform.labric.co/api/v1/tools/query', [
  'body' => '{
  "query": "SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5"
}',
  'headers' => [
    'Authorization' => 'Bearer <api_key>',
    'Content-Type' => 'application/json',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://platform.labric.co/api/v1/tools/query");
var request = new RestRequest(Method.POST);
request.AddHeader("Authorization", "Bearer <api_key>");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{\n  \"query\": \"SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5\"\n}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = [
  "Authorization": "Bearer <api_key>",
  "Content-Type": "application/json"
]
let parameters = ["query": "SELECT id, username, email FROM users WHERE active = true ORDER BY created_at DESC LIMIT 5"] as [String : Any]

let postData = JSONSerialization.data(withJSONObject: parameters, options: [])

let request = NSMutableURLRequest(url: NSURL(string: "https://platform.labric.co/api/v1/tools/query")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "POST"
request.allHTTPHeaderFields = headers
request.httpBody = postData as Data

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```