erickpinos/check-prod
.claude/skills/check-prod/SKILL.md
Query the production Vercel database via the public API to investigate data issues
$ install --global
skillsauthnpx skillsauth add erickpinos/sai-explorer check-prodInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 8:58 PM1.8s1 file scanned
SKILL.md
- name:
- check-prod
- description:
- Query the production Vercel database via the public API to investigate data issues
- disable-model-invocation:
- true
- argument-hint:
- [query description]
- allowed-tools:
- Bash, Read
Check Production Data
Query the production Sai Explorer API to investigate data in the Vercel Postgres database.
Base URL: https://sai-explorer.vercel.app
Use curl -s to fetch JSON, then pipe to python3 -c for parsing/filtering.
User Request
$ARGUMENTS
Available Endpoints
| Endpoint | Params | Description |
|----------|--------|-------------|
| /api/trades | network, limit, offset | All trades (default limit 1000) |
| /api/user-trades | network, address | Trades for a specific user |
| /api/user-stats | network, address | Aggregate stats for a user (volume, PnL, trade count) |
| /api/user-deposits | network, address | Deposits for a specific user |
| /api/user-withdraws | network, address | Withdraws for a specific user |
| /api/stats | network | Global platform stats |
| /api/volume | network | Volume leaderboard |
| /api/deposits | network | All deposits |
| /api/withdraws | network | All withdraws |
| /api/insights | network | PnL insights and analytics |
| /api/chart-data | network, type | Chart time series data |
| /api/markets | network | Market info |
| /api/collateral | network | Collateral breakdown |
| /api/tvl-breakdown | network | TVL by vault |
Default network=mainnet for all endpoints.
Key Data Mappings
- Micro-units:
collateralAmount,realizedPnlCollateral,openCollateralAmountare in micro-units (divide by 1,000,000) - USD conversion:
microAmount / 1e6 * collateralPrice - Collateral types: USDC (price ~$1.0) or stNIBI (price ~$0.005)
- Trade fields: Nested under
trade.perpBorrowing.collateralToken.symbolandtrade.perpBorrowing.baseToken.symbol - Address formats: Users have both Bech32 (
nibi1...) and EVM (0x...) addresses
Instructions
- Determine which endpoint(s) to query based on the user's request
- Fetch data with
curl -sand parse withpython3 -c - Present findings in a clear, formatted table or summary
- If investigating data quality, check for NULL values, unexpected ranges, or inconsistencies
- For large datasets, use
limitandoffsetto page through results
Related Skills
erickpinos/unfreeze
data-ai
VerifiedTrustedCommunity
Clear the freeze boundary set by /freeze, allowing edits to all directories again. Use when you want to widen edit scope without ending the session. Use when asked to "unfreeze", "unlock edits", "remove freeze", or "allow all edits".
1SKILL.mdUpdated Apr 17, 2026
erickpinos/ship
development
VerifiedTrustedCommunity
Ship workflow: detect + merge base branch, run tests, review diff, bump VERSION, update CHANGELOG, commit, push, create PR. Use when asked to "ship", "deploy", "push to main", "create a PR", or "merge and push". Proactively suggest when the user says code is ready or asks about deploying.
1SKILL.mdUpdated Apr 17, 2026
erickpinos/setup-browser-cookies
testing
VerifiedTrustedCommunity
Import cookies from your real browser (Comet, Chrome, Arc, Brave, Edge) into the headless browse session. Opens an interactive picker UI where you select which cookie domains to import. Use before QA testing authenticated pages. Use when asked to "import cookies", "login to the site", or "authenticate the browser".
1SKILL.mdUpdated Apr 17, 2026
erickpinos/review
development
VerifiedTrustedCommunity
Pre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues. Use when asked to "review this PR", "code review", "pre-landing review", or "check my diff". Proactively suggest when the user is about to merge or land code changes.
1SKILL.mdUpdated Apr 17, 2026