Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Path Parameters
database
string
required
Target database.
Body
application/json
POST /v1/sql_query/{database}.
query
string
required
rerank
object | null
Rows reranked for a question before they come back: {"question": "...", "k": 10}. The rows a query finds are each put to the
deployment's grader with the question - the pass the agent APIs'
ask ranks its results by - and the top k come back, best first,
as JSON: {"rows": [...], "rerank": {...}} with the pass's coverage.
The grader reads at most the deployment's triage pool
(ask.triage.pool): a search fetches the pool rather than its k,
and a match's or a statement's rows past the pool are neither graded
nor returned, the coverage counting them (over_pool). k is the
search's own when absent, or every row graded; a k over the pool is
refused (400). Off when absent or null. Needs a deployment with the
agent APIs and their triage pass; refused otherwise (501). Its shape
is the agent APIs' (api::rerank::Rerank), carried here as it came.
validate
null | object
Ask for the result to be checked against the question it is meant to
answer. Off when absent, and nothing about the query changes. When
present, a GROUP BY over a search function with a literal k under 300
is refused before it runs, and the response is JSON whatever Accept
says: {"rows": [...], "validation": {...}}, the verdict beside the
rows. The engine work the check spends is metered with the query.
Show child attributes
Response
Matching rows as an Arrow IPC stream (application/vnd.apache.arrow.stream), or JSON when the request sends Accept: application/json. With validate, always JSON: {"rows": [...], "validation": {...}}. The validation carries valid, check (no_rows, aggregate, anchors or unchecked), anchors (the terms read off the question), rows (how many were considered), and when the result does not answer the question, reason and absent (the terms the searched column holds nowhere, so no query will find them). For a GROUP BY over a search function it adds group_column, groups (each group's whole length in lines and its lines holding each search term) and note, so a total over the top k is not read as a size. valid: true means the rows answer something the question asked, not that the answer is right.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Infino","description":"Infino is an open-source retrieval engine for full-text, vector, and SQL search, with your data stored as Apache Parquet on object storage.","colors":{"primary":"#d24011","light":"#e8623a","dark":"#d24011"},"logo":{"light":"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f","dark":"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f","href":"https://infino.ai"},"favicon":"https://mintcdn.com/infino-29/LrgKEC9MS1pd7XX7/favicon.png?fit=max\u0026auto=format\u0026n=LrgKEC9MS1pd7XX7\u0026q=85\u0026s=e08bd7081efa9de5d611ea206ba6e46c","navbar":{"links":[{"href":"https://infino.ai","label":"Home"},{"href":"https://infino.ai/vs","label":"Compare"},{"href":"https://infino.ai/cloud","label":"Infino Cloud"},{"href":"https://github.com/infino-ai/infino","label":"GitHub"}],"primary":{"type":"button","label":"Talk to us","href":"mailto:[email protected]"}},"footer":{"socials":{"github":"https://github.com/infino-ai/infino"},"links":[{"header":"Resources","items":[{"label":"GitHub","href":"https://github.com/infino-ai/infino"},{"label":"Issues","href":"https://github.com/infino-ai/infino/issues"}]}]},"search":{"prompt":"Search the Infino docs…"},"seo":{"metatags":{"canonical":"https://infino.ai/docs","og:site_name":"Infino","og:type":"website","og:image":"/images/og-card.png","twitter:card":"summary_large_image","twitter:image":"/images/og-card.png"},"indexing":"all"},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"metadata":{"timestamp":true},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"infino-29","hasAudioNarration":false,"actualSubdomain":"infino-29","customDomains":["infino.ai"],"gitSource":{"type":"github","owner":"infino-ai","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"feedback":{"agentFeedback":true,"thumbs":true},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6affba0a573a46cca85c4cc5","clientVersion":"0.0.4248","searchFilterCounts":[{"language":"default","tag":"Documentation","count":26},{"language":"default","tag":"API Reference","count":21},{"language":"default","tag":"REST API","count":18},{"language":"default","tag":"Infino Cloud","count":10},{"language":"default","tag":"Guides","count":9},{"language":"default","tag":"Search","count":7},{"language":"default","tag":"Reference","count":4},{"language":"default","tag":"Databases","count":4},{"language":"default","tag":"Tables","count":4},{"language":"default","tag":"SDKs \u0026 CLI","count":3}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"/docs","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[]}
{"page":{"pagePath":"api-reference/search/run-a-sql-query","slug":"/api-reference/search/run-a-sql-query","pageMetadata":{"title":"Run a SQL query","description":"Run a read-only SQL query across the database's tables.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/query_sql/{database}","href":"/api-reference/search/run-a-sql-query","autogeneratedByOpenApi":true},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Run a read-only SQL query across the database’s tables.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Run a SQL query","description":"Run a read-only SQL query across the database's tables.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/query_sql/{database}","href":"/api-reference/search/run-a-sql-query","autogeneratedByOpenApi":true}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/infino-29/645d308d2f9fae79/structured-data.js","/docs/_mintlify/custom/infino-29/ec3d5239f2e7ff69/same-tab-links.js","/docs/_mintlify/custom/infino-29/cf391a6d1558677e/context7-widget.js"],"openApiReferenceData":{"operation":{"tags":["Search"],"summary":"Run a SQL query","description":"Run a read-only SQL query across the database's tables.","operationId":"sql_query","parameters":["c52e2167-4438-4374-a041-4826940d74a7"],"requestBody":"7b86d479-8e11-41f7-ad18-31786a527b72","responses":{"200":"aa9136a6-5c5c-4be1-8144-2b4267c49bf4","400":"c0c0e18c-a3fb-485b-9065-df6a2b0007a3","401":"fa23f180-3b51-495f-ac1f-9bf674983409","503":"60548126-5e6c-42f1-bdc0-f24183bde97b"},"security":["2db670de-0894-4339-ae38-a8de2d7397dd"],"method":"post","type":"path","servers":["23d9a646-e57e-43fe-b890-813659629bf1"],"path":"/v1/query_sql/{database}","baseUrlOptions":["https://api.platform.infino.ws"],"title":"Run a SQL query","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"c52e2167-4438-4374-a041-4826940d74a7":{"name":"database","in":"path","description":"Target database.","required":true,"schema":{"type":"string","isRequired":true,"description":"Target database.","uniqueKey":"","typeLabel":"string"}}},"requestBody":{"content":{"application/json":{"schema":{"type":"object","description":"`POST /v1/sql_query/{database}`.","required":["query"],"properties":{"query":{"type":"string","isRequired":true,"uniqueKey":"query","typeLabel":"string"},"rerank":{"oneOf":[{"type":"object","description":"Rows reranked for a question before they come back: `{\"question\":\n\"...\", \"k\": 10}`. The rows a query finds are each put to the\ndeployment's grader with the question - the pass the agent APIs'\n`ask` ranks its results by - and the top `k` come back, best first,\nas JSON: `{\"rows\": [...], \"rerank\": {...}}` with the pass's coverage.\nThe grader reads at most the deployment's triage pool\n(`ask.triage.pool`): a search fetches the pool rather than its `k`,\nand a match's or a statement's rows past the pool are neither graded\nnor returned, the coverage counting them (`over_pool`). `k` is the\nsearch's own when absent, or every row graded; a `k` over the pool is\nrefused (400). Off when absent or `null`. Needs a deployment with the\nagent APIs and their triage pass; refused otherwise (501). Its shape\nis the agent APIs' (`api::rerank::Rerank`), carried here as it came.","uniqueKey":"rerank.oneOf.0","typeLabel":"object"},{"type":"null","description":"Rows reranked for a question before they come back: `{\"question\":\n\"...\", \"k\": 10}`. The rows a query finds are each put to the\ndeployment's grader with the question - the pass the agent APIs'\n`ask` ranks its results by - and the top `k` come back, best first,\nas JSON: `{\"rows\": [...], \"rerank\": {...}}` with the pass's coverage.\nThe grader reads at most the deployment's triage pool\n(`ask.triage.pool`): a search fetches the pool rather than its `k`,\nand a match's or a statement's rows past the pool are neither graded\nnor returned, the coverage counting them (`over_pool`). `k` is the\nsearch's own when absent, or every row graded; a `k` over the pool is\nrefused (400). Off when absent or `null`. Needs a deployment with the\nagent APIs and their triage pass; refused otherwise (501). Its shape\nis the agent APIs' (`api::rerank::Rerank`), carried here as it came.","uniqueKey":"rerank.oneOf.1","typeLabel":"null"}],"uniqueKey":"rerank","typeLabel":"object | null"},"validate":{"oneOf":[{"type":"null","uniqueKey":"validate.oneOf.0","typeLabel":"null"},{"type":"object","description":"Ask for the result to be checked against the question it is meant to\nanswer. Off when absent, and nothing about the query changes. When\npresent, a GROUP BY over a search function with a literal k under 300\nis refused before it runs, and the response is JSON whatever `Accept`\nsays: `{\"rows\": [...], \"validation\": {...}}`, the verdict beside the\nrows. The engine work the check spends is metered with the query.","required":["table_name","field_name"],"properties":{"field_name":{"type":"string","description":"The full-text-indexed column the statement searched.","isRequired":true,"uniqueKey":"validate.oneOf.1.field_name","typeLabel":"string"},"table_name":{"type":"string","description":"The table the statement searched.","isRequired":true,"uniqueKey":"validate.oneOf.1.table_name","typeLabel":"string"},"question":{"oneOf":[{"type":"string","description":"The question the rows are meant to answer. Its distinctive terms\n(numbers, quoted spans, names, identifiers) are what the rows must\nmention. Without it, only an empty or all-zero result is refused.","uniqueKey":"validate.oneOf.1.question.oneOf.0","typeLabel":"string"},{"type":"null","description":"The question the rows are meant to answer. Its distinctive terms\n(numbers, quoted spans, names, identifiers) are what the rows must\nmention. Without it, only an empty or all-zero result is refused.","uniqueKey":"validate.oneOf.1.question.oneOf.1","typeLabel":"null"}],"uniqueKey":"validate.oneOf.1.question","typeLabel":"string | null"}},"additionalProperties":false,"uniqueKey":"validate.oneOf.1","typeLabel":"object"}],"uniqueKey":"validate","typeLabel":"null | object"}},"additionalProperties":false,"uniqueKey":"","typeLabel":"object"},"examples":{"Example":{"title":"Example","value":{"query":"\u003cstring>","rerank":{},"validate":{"field_name":"\u003cstring>","table_name":"\u003cstring>","question":"\u003cstring>"}}}},"exampleType":"generated"}},"required":true,"exampleType":"generated"},"responses":{"aa9136a6-5c5c-4be1-8144-2b4267c49bf4":{"description":"Matching rows as an Arrow IPC stream (application/vnd.apache.arrow.stream), or JSON when the request sends `Accept: application/json`. With `validate`, always JSON: `{\"rows\": [...], \"validation\": {...}}`. The validation carries `valid`, `check` (`no_rows`, `aggregate`, `anchors` or `unchecked`), `anchors` (the terms read off the question), `rows` (how many were considered), and when the result does not answer the question, `reason` and `absent` (the terms the searched column holds nowhere, so no query will find them). For a GROUP BY over a search function it adds `group_column`, `groups` (each group's whole length in lines and its lines holding each search term) and `note`, so a total over the top k is not read as a size. `valid: true` means the rows answer something the question asked, not that the answer is right.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"c0c0e18c-a3fb-485b-9065-df6a2b0007a3":{"description":"Invalid request body. With `validate`, also a GROUP BY over a search function with a literal k under 300, refused before it runs because its totals rank a share of the top k rather than the table; the message names the call and the two shapes that rank the whole table. Not transient: rewrite the statement.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"fa23f180-3b51-495f-ac1f-9bf674983409":{"description":"Missing or invalid API key.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"60548126-5e6c-42f1-bdc0-f24183bde97b":{"description":"The database's workers are still activating, or no capacity is free to place them. Transient — retry after the `Retry-After` interval.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}}},"security":{"2db670de-0894-4339-ae38-a8de2d7397dd":{"api_key":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"api_key"}}},"servers":{"23d9a646-e57e-43fe-b890-813659629bf1":{"url":"https://api.platform.infino.ws","description":"Infino Cloud"}},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"http","scheme":"bearer","scopes":[],"schemeName":"api_key"},"schema":{"title":"Bearer Auth","type":"string","isRequired":true,"description":"Bearer authentication header of the form `Bearer \u003ctoken>`, where `\u003ctoken>` is your auth token.","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"api_key","name":"Authorization"}],"title":"api_key"}]},"originalFileLocation":"api-reference/openapi.json"},"subdomain":"infino-29","siteName":"Infino","title":"Run a SQL query - Infino","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"originalFileLocation":"api-reference/search/run-a-sql-query.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Run a read-only SQL query across the database\u0026#x27;s tables.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Infino\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Run a SQL query - Infino\">\u003cmeta data-mint-head property=\"og:description\" content=\"Run a read-only SQL query across the database\u0026#x27;s tables.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Infino\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://infino.ai/docs/api-reference/search/run-a-sql-query\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://infino-29.mintlify.site/docs/images/og-card.png\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Run a SQL query - Infino\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Run a read-only SQL query across the database\u0026#x27;s tables.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://infino-29.mintlify.site/docs/images/og-card.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/infino-29/QxzEBvRaDzIUbPUA/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Infino\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#d24011\">\u003clink data-mint-head rel=\"canonical\" href=\"https://infino.ai/docs/api-reference/search/run-a-sql-query\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/api-reference/search/run-a-sql-query.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://infino.ai/#organization\",\"name\":\"Infino\",\"url\":\"https://infino.ai\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/infino-29/sXqDYmwcZ7BW4kvO/logo/infino-logo.png?fit=max\u0026auto=format\u0026n=sXqDYmwcZ7BW4kvO\u0026q=85\u0026s=6bf8ba5e6249a14bb302a90e30e5e18f\"}},{\"@type\":\"WebSite\",\"@id\":\"https://infino.ai/docs#website\",\"name\":\"Infino\",\"url\":\"https://infino.ai/docs\",\"publisher\":{\"@id\":\"https://infino.ai/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query#webpage\",\"url\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query\",\"name\":\"Run a SQL query\",\"description\":\"Run a read-only SQL query across the database's tables.\",\"isPartOf\":{\"@id\":\"https://infino.ai/docs#website\"},\"breadcrumb\":{\"@id\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"REST API\",\"item\":\"https://infino.ai/docs/api-reference/rows/append-rows\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Search\",\"item\":\"https://infino.ai/docs/api-reference/search/bm25-full-text-search\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Run a SQL query\",\"item\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query#apireference\",\"headline\":\"Run a SQL query\",\"name\":\"Run a SQL query\",\"description\":\"Run a read-only SQL query across the database's tables.\",\"url\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query\",\"mainEntityOfPage\":{\"@id\":\"https://infino.ai/docs/api-reference/search/run-a-sql-query#webpage\"},\"image\":\"https://infino.ai/images/og-card.png\",\"publisher\":{\"@id\":\"https://infino.ai/#organization\"},\"isPartOf\":{\"@id\":\"https://infino.ai/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Infino\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Infino\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/api-reference/search/run-a-sql-query.md","siteName":"Infino","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":""}]},{"tab":"Integrations","pages":[{"title":"Integrations","href":"/integrations/mcp"}]},{"tab":"Tutorials","pages":[{"title":"Tutorials","href":"/tutorials"}]},{"tab":"Use Cases","pages":[{"title":"Use Cases","href":"/use-cases"}]},{"tab":"Demos","pages":[{"title":"Demos","href":"/demos"}]},{"tab":"API Reference","groups":[{"group":"SDKs \u0026 CLI","pages":[{"title":"Overview","icon":"code","href":"/api-reference"},{"title":"Local vs Infino Cloud","icon":"table-columns","href":"/api-reference/parity"},{"title":"Infino CLI: create tables, ingest, and search","icon":"terminal","href":"/cli"}]},{"group":"REST API","pages":[{"group":"Rows","pages":[{"title":"Append rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/append/{database}","href":"/api-reference/rows/append-rows"},{"title":"Delete rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/delete/{database}","href":"/api-reference/rows/delete-rows"},{"title":"Update rows","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/update/{database}","href":"/api-reference/rows/update-rows"}]},{"group":"Search","pages":[{"title":"BM25 full-text search","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/bm25_search/{database}","href":"/api-reference/search/bm25-full-text-search"},{"title":"Count matches","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/count/{database}","href":"/api-reference/search/count-matches"},{"title":"Exact match","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/exact_match/{database}","href":"/api-reference/search/exact-match"},{"title":"Hybrid search","description":"Hybrid BM25 and vector search, fused with reciprocal-rank fusion.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/hybrid_search/{database}","href":"/api-reference/search/hybrid-search"},{"title":"Run a SQL query","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/query_sql/{database}","href":"/api-reference/search/run-a-sql-query"},{"title":"Token match","description":"Unranked token match over a full-text-indexed column.","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/token_match/{database}","href":"/api-reference/search/token-match"},{"title":"Vector search","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/vector_search/{database}","href":"/api-reference/search/vector-search"}]},{"group":"Tables","pages":[{"title":"Create a table","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/create_table/{database}","href":"/api-reference/tables/create-a-table"},{"title":"Drop a table","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/drop_table/{database}","href":"/api-reference/tables/drop-a-table"},{"title":"List tables","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/list_tables/{database}","href":"/api-reference/tables/list-tables"},{"title":"Describe or change a table's schema","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/schema/{database}","href":"/api-reference/tables/describe-or-change-a-tables-schema"}]},{"group":"Databases","pages":[{"title":"List databases","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json get /v1/databases","href":"/api-reference/databases/list-databases"},{"title":"Create a database","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/databases","href":"/api-reference/databases/create-a-database"},{"title":"Delete a database","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json delete /v1/databases/{name}","href":"/api-reference/databases/delete-a-database"},{"title":"Verify a storage binding","deprecated":null,"version":null,"openapi":"/api-reference/openapi.json post /v1/databases/{name}/storage/verify","href":"/api-reference/databases/verify-a-storage-binding"}]}]}]}]},"basePath":"","title":"Run a SQL query - Infino","deploymentId":"dpl_C8nwD4Qo785i7PBDK32YZuKGR9Lm","buildId":"dpl_C8nwD4Qo785i7PBDK32YZuKGR9Lm","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-BHpAblIa.js","snippetPresets-C-QjF0k_.js","utils-Dz5URj_u.js","style-to-object-BY3JEAdk.js","utils-Da_yhPn5.js","v4-DIgz8zy6.js","addUniqueKeysToSchema-CIIxiDBb.js","conditional-requirements-CFM0id0Q.js","cloneDeep-k_8athT8.js","_Uint8Array-3TACpfVy.js","isObject-FP1Yky1u.js","ApiExamples-BwENSgQX.js","usePlaygroundInputsStore-Bwm_Juam.js","shallow-DiWjILlR.js","isEqual-D8db76Nf.js","CodeSnippets-DkFc-r7T.js","CodeSnippet-DzxI2vN3.js","getApiPlaygroundDisplay-Co0Ej2uF.js","Page-Dq2tE-AS.js","DynamicMarkdown-3piqoEk_.js","SectionHeading-BfyA8rV0.js","icon-Dz7YG_yb.js","MethodPill-D7hco0-Q.js","getPastedJson-DYtIXN3i.js","DuplicateIcon-CWgJhuEu.js","axios-CsQoIw0U.js","Markdown-Bj6sjipA.js","AssistantPageLink-vuoZnuCk.js","dist-Bb1ZYRob.js","lib-DMeTj1gb.js","lib-B8HbPgcC.js","katex-Dbtb6Wk7.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js"]}