Ask your data a question

Open the SQL editorCopy Anchor Link

Go to DataSQL editor. The side panel lists your schemas and tables; Find a table searches. Click a name to insert it, or start from Preview rows or Count rows.

Look at the rowsCopy Anchor Link

SELECT * FROM orders LIMIT 100

Select Run or press Cmd Enter (Ctrl Enter on Windows). The rows appear below with the row count.

Count themCopy Anchor Link

SELECT COUNT(*) AS orders FROM orders

Answer a questionCopy Anchor Link

Which customers spent the most last month?

SELECT customer, SUM(amount) AS total
FROM orders
WHERE created_at >= DATE '2026-10-01' AND created_at < DATE '2026-11-01'
GROUP BY customer
ORDER BY total DESC
LIMIT 10

Read the cost before you runCopy Anchor Link

Above the results, the editor shows how much data the query reads, and warns before running one your plan does not allow. Narrow it with a WHERE clause on a date or key.

ConnectCopy Anchor Link

from klarety import Nexus

nx = Nexus.connect()  # reads KLARETY_API_KEY

Run a queryCopy Anchor Link

result = nx.sql("SELECT * FROM orders LIMIT 100")
print(len(result), "rows, read", result.bytes_scanned, "bytes")
for row in result.rows[:5]:
    print(row)

Pass values safelyCopy Anchor Link

Use :name placeholders and params. Each value is filled in as a string literal, never as SQL, so cast it where a number or date is meant:

top = nx.sql(
    """
    SELECT customer, SUM(amount) AS total
    FROM orders
    WHERE created_at >= CAST(:start AS DATE) AND created_at < CAST(:end AS DATE)
    GROUP BY customer
    ORDER BY total DESC
    LIMIT 10
    """,
    params={"start": "2026-10-01", "end": "2026-11-01"},
)
print(top.rows)

Estimate before runningCopy Anchor Link

estimate tells you what a statement would read and whether your plan allows it, without running it.

print(nx.estimate("SELECT * FROM orders"))

Read a large resultCopy Anchor Link

max_rows is 1 to 10,000, and at most your plan's page of rows comes back at once. When more rows exist, truncated is true and result_rows reads every row:

result = nx.sql("SELECT * FROM orders", max_rows=10000)
if result.truncated:
    for row in nx.result_rows(result):
        ...