{"tables": {"candidates": {"rows": 4748202, "columns": {"id": "VARCHAR", "name": "VARCHAR", "email": "VARCHAR", "linkedin_user": "VARCHAR", "twitter_user": "VARCHAR", "github_user": "VARCHAR", "personal_url": "VARCHAR", "image_src": "VARCHAR", "one_liner": "VARCHAR", "title": "VARCHAR", "about": "VARCHAR", "location_raw": "VARCHAR", "city": "VARCHAR", "state": "VARCHAR", "country": "VARCHAR", "region": "VARCHAR", "tags": "VARCHAR[]", "funding_tags": "VARCHAR[]", "growth_tags": "VARCHAR[]", "industry_tags": "VARCHAR[]", "likeliness_to_leave": "VARCHAR", "likeliness_to_leave_reasons": "VARCHAR", "candidate_talent_density_score": "DOUBLE", "scrape_source": "VARCHAR", "is_top_cs_school": "BOOLEAN", "is_top_school": "BOOLEAN", "created_at": "TIMESTAMP", "updated_at": "TIMESTAMP", "current_title": "VARCHAR", "current_company": "VARCHAR", "current_company_id": "VARCHAR", "current_company_size": "BIGINT", "current_company_industry": "VARCHAR", "current_company_funding_stage": "VARCHAR", "current_company_funding_rank": "INTEGER", "current_company_funding_amount": "BIGINT", "current_company_founded_year": "BIGINT", "current_company_location": "VARCHAR", "current_company_label": "VARCHAR", "current_company_ai_tags": "VARCHAR", "current_company_categories": "VARCHAR", "current_start_date": "DATE", "current_tenure_months": "BIGINT", "current_employment_type": "VARCHAR", "all_titles": "VARCHAR", "all_companies": "VARCHAR", "all_industries": "VARCHAR", "has_big_tech_exp": "BOOLEAN", "has_startup_exp": "BOOLEAN", "has_founder_title": "BOOLEAN", "has_founding_eng_title": "BOOLEAN", "smallest_company_size": "BIGINT", "largest_company_size": "BIGINT", "total_experience_years": "DOUBLE", "num_jobs": "BIGINT", "schools": "VARCHAR", "degrees": "VARCHAR", "highest_degree": "VARCHAR", "all_school_ai_tags": "VARCHAR", "searchable_text": "VARCHAR"}}, "experiences": {"rows": 29677727, "columns": {"id": "VARCHAR", "candidate_id": "VARCHAR", "role_title": "VARCHAR", "start_date": "DATE", "end_date": "DATE", "is_current": "BOOLEAN", "location": "VARCHAR", "employment_type": "VARCHAR", "description": "VARCHAR", "company_name": "VARCHAR", "company_id": "VARCHAR", "company_size": "BIGINT", "company_industry": "VARCHAR", "company_funding_stage": "VARCHAR", "company_funding_rank": "INTEGER", "company_funding_amount": "BIGINT", "company_founded_year": "BIGINT", "company_location": "VARCHAR", "company_ai_tags": "VARCHAR", "company_categories": "VARCHAR", "company_specialities": "VARCHAR", "company_label": "VARCHAR"}}}, "endpoints": {"POST /search": "Search candidates with structured filters", "POST /sql": "Run raw SELECT queries (read-only)", "POST /experiences": "Query experiences by candidate_id or company_name", "GET /schema": "This endpoint", "GET /health": "Health check"}, "filters": {"text_filters": {"description": "Case-insensitive partial match (ILIKE '%value%')", "fields": ["name", "current_title", "current_company", "all_titles", "all_companies", "all_industries", "schools", "location", "searchable_text"]}, "search": {"description": "Broad text search across: name, one_liner, current_title, current_company, all_titles", "type": "string"}, "range_filters": {"description": "Numeric range with 'gte' and/or 'lte'", "fields": ["total_experience_years", "num_jobs", "current_tenure_months", "current_company_size", "current_company_funding_rank", "current_company_funding_amount", "candidate_talent_density_score", "smallest_company_size", "largest_company_size"]}, "array_filters": {"description": "Match against array columns (OR within filter)", "fields": ["tags", "funding_tags", "growth_tags", "industry_tags"]}, "boolean_filters": {"description": "Exact boolean match", "fields": ["has_big_tech_exp", "has_startup_exp", "has_founder_title", "has_founding_eng_title", "is_top_cs_school", "is_top_school"]}, "exact_filters": {"description": "Exact string match", "fields": ["region", "country", "city", "highest_degree", "current_company_funding_stage", "likeliness_to_leave"]}}, "selectable_fields": ["about", "all_companies", "all_industries", "all_titles", "candidate_talent_density_score", "city", "country", "current_company", "current_company_funding_amount", "current_company_funding_rank", "current_company_funding_stage", "current_company_industry", "current_company_location", "current_company_size", "current_employment_type", "current_start_date", "current_tenure_months", "current_title", "degrees", "email", "funding_tags", "github_user", "growth_tags", "has_big_tech_exp", "has_founder_title", "has_founding_eng_title", "has_startup_exp", "highest_degree", "id", "industry_tags", "is_top_cs_school", "is_top_school", "largest_company_size", "likeliness_to_leave", "linkedin_url", "linkedin_user", "location_raw", "name", "num_jobs", "one_liner", "personal_url", "region", "schools", "smallest_company_size", "state", "tags", "title", "total_experience_years", "twitter_user"], "default_select_fields": ["name", "email", "linkedin_url", "current_title", "current_company", "region", "total_experience_years", "one_liner"], "sortable_fields": ["candidate_talent_density_score", "current_company_funding_rank", "current_company_size", "current_tenure_months", "id", "name", "num_jobs", "total_experience_years"], "limits": {"default_limit": 100, "max_limit": 1000, "rate_limit": "30 requests per 60s per IP"}, "example_requests": {"search": {"filters": {"current_title": "software engineer", "region": "Bay Area", "has_startup_exp": true, "total_experience_years": {"gte": 3, "lte": 8}}, "select": ["name", "email", "linkedin_url", "current_title", "current_company", "total_experience_years"], "sort_by": "total_experience_years", "sort_order": "desc", "limit": 20}, "sql": {"sql": "SELECT name, current_title, current_company FROM candidates WHERE region = 'Bay Area' AND has_founder_title = true LIMIT 10"}, "experiences": {"company_name": "Google", "limit": 50}}}