{"uid":"cap_2aJZvdQSCqJhtgmQXS8xI","slug":"database-query-runs-numeric-row-ordering-1fb6ac53","name":"Database Query Runs – Numeric Row Ordering","description":"Database query runs - Numeric row ordering: Numeric row ordering for Database query runs. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded numeric row ordering report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-database-query-runs-sort?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","database","date","execution_ms","rows_scanned"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"database":{"type":"string","default":"","maxLength":80},"execution_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rows_scanned":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","database":"group-a","execution_ms":10,"rows_scanned":1},{"date":"2026-10-02","row_id":"row-2","database":"group-b","execution_ms":20,"rows_scanned":2},{"date":"2026-10-03","row_id":"row-3","database":"group-a","execution_ms":15,"rows_scanned":3},{"date":"2026-10-04","row_id":"row-4","database":"group-b","execution_ms":30,"rows_scanned":4}],"maxItems":200,"minItems":1},"field":{"enum":["execution_ms","rows_scanned"],"type":"string","default":"execution_ms"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_AnK7JQgE4c2nEH6PhddcT","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Sorts up to 200 database query run records by a chosen numeric field (execution_ms or rows_scanned) and returns a ranked, ordered report for local descriptive analytics.","exampleAgentPrompt":"Sort these 4 database query run records by execution_ms and give me the numeric row ordering report: row-1 on 2026-10-01 in group-a took 10ms and scanned 1 row, row-2 on 2026-10-02 in group-b took 20ms and scanned 2 rows, row-3 on 2026-10-03 in group-a took 15ms and scanned 3 rows, row-4 on 2026-10-04 in group-b took 30ms and scanned 4 rows.","exampleUseCases":[{"title":"Rank queries by slowest execution time","prompt":"I have a batch of database query runs from last week across group-a and group-b — can you sort them by execution_ms so I can see which queries are the slowest? Here are the records: row-1 (2026-10-01, group-a, 250ms, 500 rows), row-2 (2026-10-02, group-b, 1200ms, 3000 rows), row-3 (2026-10-03, group-a, 80ms, 150 rows)."},{"title":"Identify high row-scan queries","prompt":"Sort these query run records by rows_scanned so I can figure out which queries are doing the most table scanning — row-1 (2026-10-01, group-a, 300ms, 12000 rows), row-2 (2026-10-02, group-b, 150ms, 450 rows), row-3 (2026-10-03, group-a, 900ms, 55000 rows), row-4 (2026-10-04, group-b, 200ms, 2100 rows)."},{"title":"Compare query performance across databases","prompt":"I want to compare query performance across my two databases. Here are 5 query runs — can you order them by execution_ms? row-1 (2026-10-01, prod-db, 400ms, 800 rows), row-2 (2026-10-02, staging-db, 60ms, 100 rows), row-3 (2026-10-03, prod-db, 1100ms, 9000 rows), row-4 (2026-10-04, staging-db, 320ms, 600 rows), row-5 (2026-10-05, prod-db, 750ms, 4500 rows)."}],"resultDescription":"A bounded numeric row ordering report listing the supplied database query run records ranked/sorted by the chosen numeric field (execution_ms or rows_scanned), up to 200 rows. The output is a local descriptive analytics report with no enrichment or forecasting — pure rank ordering of the submitted data.","failureModes":["Empty rows array (minItems:1 violated) returns validation error","More than 200 rows submitted (maxItems:200 violated) returns error","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, database, date, execution_ms, rows_scanned) triggers error","Invalid field enum value (not 'execution_ms' or 'rows_scanned') causes rejection","Null numeric values may result in null-aware ordering behavior"],"whenToPreferThis":"Choose this endpoint when you have up to 200 database query run records and need a simple, cheap ($0.01 USDC) numeric sort/rank by execution time or rows scanned with no external enrichment, forecasting, or complex aggregation. Ideal for lightweight local analytics pipelines, quick performance triage, or agent-driven database observability tasks where you just need ranked ordering of query data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T07:45:43.413Z","isFirstParty":false,"canonicalSlug":"database-query-runs-numeric-row-ordering-1fb6ac53"}