Onboarding / SDKs
There is no connection string to paste. You connect by installing one of the shipped surfaces, setting IAM credentials, and running a query against the read-only Redshift Data API. Here is the path to your first query — measured in minutes, not migrations.
Path to first query
Install a surface
Pick whichever surface matches how you work. Each ships the same warehouse access underneath.
pip install -e …/cli-product-redshift → asdcheck / ./checkThe asdcheck test harness that validates the warehouse.
pip install -e '.[mcp]' then asdcheck mcpExposes the canned questions as MCP tools.
claude mcp add asdcheck-redshift (see root .mcp.json)Natural-language questions → SQL, in Claude.
bun install + bun run test:e2ePersonas: quiver / connector / pressbox / bookmaker / grandstand.
Authenticate
IAM auth over HTTPS — no VPC, no JDBC/ODBC driver, no password.
Credentials you'll set
AWS_ACCESS_KEY_IDAWS_SECRET_ACCESS_KEYREGION=us-west-1WORKGROUP=default-workgroupDATABASE=devDB_USERThe issued credential cannot INSERT, UPDATE, or DELETE — it is read-only by construction.
Run your first query
execute → poll → fetch. ~1.5–2s per statement.
Not ready to install? Try a query in the browser first against the offline snapshot.
Open the Query PlaygroundConnection facts
Region
us-west-1
Workgroup
default-workgroup
Database
dev
Access
read-only
Engine & API
Amazon Redshift Serverless via Redshift Data API (HTTPS, IAM auth)
- No VPC, no JDBC/ODBC driver, no password, no connection string.
- The issued credential cannot INSERT, UPDATE, or DELETE.
- Data API is asynchronous + paged: execute_statement → poll describe_statement → get_statement_result, following NextToken to exhaustion (a single get_statement_result silently returns only the first page).
- Expect ~1.5–2s latency per statement regardless of result size — batch questions into one query.
- Timestamps are `timestamp without time zone`, UTC by convention (..._utc). Do not let a driver localize them.
This is the developer-onboarding surface.
The final production location will be api.altsportsdata.com/v1/api/resources/ — today testing at platform.altsportsleagues.ai.
Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).