One Click Indexer

Turn a Solana program ID into a runnable SQD indexer in one flow.

Paste a program ID, inspect live Portal samples, generate a starter indexer, preview the files, and export the whole project as a ZIP.

What It Does

• Samples live Solana data from SQD Portal
• Infers a safe starter mode for the program
• Generates a Pipes-based indexer project
• Shows the output in a compact editor-style workspace
• Exports the full starter as a ZIP file
• Stores projects locally in development or in Vercel Blob in production

Why It Helps

Indexers are usually slowed down by the same first-mile work:

• figuring out what the program is doing
• choosing the right filters
• building a first schema
• making sure the starter is actually runnable

One Click Indexer compresses that setup into a guided workflow that gives teams a real starting point instead of a blank repo.

How It Works

1. Paste a Solana programId.
2. The app samples recent instructions and transaction context.
3. It chooses a conservative indexing mode and selector strategy.
4. It generates a starter SQD project.
5. You preview the files in the editor.
6. You export the full project as a ZIP.

Stack

• Next.js 16
• React 19
• SQD Portal
• SQD Pipes
• Vercel Blob for production storage
• JSZip for ZIP exports

Local Development

npm install
npm run dev

Open http://localhost:3000.

Environment

Copy .env.example to .env.local for local development.

For production, set:

• BLOB_READ_WRITE_TOKEN
• SOLANA_RPC_URL
• PORTAL_DATASET_URL
• SAMPLE_INSTRUCTION_LIMIT
• SAMPLE_WINDOWS
• TRANSACTION_INSPECTION_LIMIT

Example production values are in .env.production.

Production

This app is Vercel-ready.

npm run build
npm start

On Vercel, set BLOB_READ_WRITE_TOKEN so project storage uses Vercel Blob. If the token is not set, the app falls back to /tmp/sqd-ai-data, which avoids read-only filesystem errors but is ephemeral and can disappear between serverless invocations.

Export

The Export zip button downloads the full generated starter project as a ZIP archive, including:

• .env.example
• README.md
• migrations/001_create_tables.sql
• package.json
• src/index.ts
• tsconfig.json

Testing

npm test

Notes

• The app is optimized for Solana programs.
• The generated starter is intentionally conservative: it aims to work for common real-world programs, not every possible edge case.
• Local file storage is used only as a dev fallback when BLOB_READ_WRITE_TOKEN is not set. In Vercel serverless, that fallback is /tmp/sqd-ai-data; use Vercel Blob for durable projects and exports.