General

ESCAPE HATCH (advanced): run ONE read-only SELECT against this org's data, RLS-isolated (cannot see other orgs, cannot write)

ESCAPE HATCH (advanced): run ONE read-only SELECT against this org's data, RLS-isolated (cannot see other orgs, cannot write). Use ONLY when query_data does not cover the question; returns the rows as-is. Tables: store_orders (+ store_connections via store_connection_id; no org_id), meta_ad_creatives (Meta metrics per ad per day), meta_ad_creatives_con_anuncio (same rows + ad copy, URLs, media), ad_accounts. Return explicit columns. Only standard functions (aggregates, window, text, dates, json); no comments, $, or schema-qualified calls.

post/api/v1/run_readonly_sql

Request

  • Base URL: https://api.pymaia.com
  • URL: https://api.pymaia.com/api/v1/run_readonly_sql
  • Auth: HTTP bearer

Request body

sqlstring required

Response

Tool executed successfully

okboolean
resultunknown
duration_msnumber

Changes

No recorded changes to this operation across all 1 revision of this API.