w3-io/W3 Space and Time Action

Decentralized SQL queries and blockchain data via Space and Time

View on GitHub

Trust Signals

Scorecard Score
not yet scored
Maintenance Recency
Stale
License
None
namedescriptionrequireddefault
commandOperation: query, execute, ddl, list-chains, discover-schemas, discover-tables, discover-columns, discover-primary-keys, discover-indexes, discover-relationships, put-entity, get-entity, query-entities (transaction / object-store-put / object-store-get raise NOT_SUPPORTED)yes
api-urlSxT API base URL for SQL and discovery (default: api.makeinfinite.dev for login/JWT mode, proxy for api-key mode)no
proxy-urlMake Infinite proxy base URL for login and biscuit lookupnohttps://proxy.api.makeinfinite.dev
api-keySxT API key (Gateway Proxy, read-only indexed data)no
auth-urlCustom JWT token endpoint URL (alternative to api-key)no
auth-secretShared secret for custom JWT endpointno
user-idSxT userId for proxy login (enables DDL/DML via biscuit-name)no
passwordSxT password for proxy loginno
biscuit-nameName of a biscuit registered on the proxy, fetched at runtimeno
biscuitPre-fetched biscuit token string (alternative to biscuit-name)no
schema-nameDefault schema for resource scoping (e.g. "ETHEREUM", "myapp")yes
origin-appApplication identifier for request trackingnow3-sxt-action
sqlSQL statement to execute. WARNING: User-controlled values must not be interpolated directly into SQL strings. Use parameterized values or validate inputs before constructing SQL.no
resourcesComma-separated table references for performance optimization (e.g. "schema.table1,schema.table2")no
query-typeQuery type for DQL: OLTP or OLAP (default: OLTP)noOLTP
schemaSchema for discovery commands (overrides schema-name for discover-tables, discover-columns, etc.)no
tableTable name for discovery commands (discover-columns, discover-primary-keys, discover-indexes, discover-relationships)no
chainBlockchain name for list-chains (e.g. "ethereum")no
tenant-idTenant scope, bound on every state read/write (multi-tenant isolation)no
entity-typeEntity type, e.g. "Gift" | "User" | "Recipient" | "Asset" (a column value, never a table name)no
idEntity id (unique within tenant + entity-type)no
fieldsJSON object: the full entity, or a partial patch merged onto the latest version (put-entity)no
expected-versionOptimistic-concurrency token for put-entity; if it does not match the current latest version, the command fails PRECONDITION_FAILEDno
filterquery-entities: JSON PostgREST-style filter, e.g. {"status":{"eq":"completed"},"amount":{"gt":100}} (operators: eq/neq/in/like/contains/gt/gte/lt/lte/is_null)no
sortquery-entities: JSON array of {field, direction}, most-significant first; direction is "asc" (default) or "desc"no
limitquery-entities: max rows (default 50, capped at 500)no
max-retriesMaximum retry attempts (default: 3)no3
retry-delayBase retry delay in seconds (default: 2)no2
timeoutRequest timeout in seconds (default: 30)no30
namedescription
resultJSON result of the operation
error-codeTyped error code on failure: NOT_SUPPORTED | RATE_LIMITED | UPSTREAM_FAILURE | INVALID_INPUT | NOT_FOUND | PRECONDITION_FAILED