exportData
ChatGPTExport the full result of a read-only SQL query as a CSV download in a single call: runs the query, rejects without charge when the actual rows exceed the required user-approved maxCredits ceiling, charges one credit per CSV row otherwise, and returns a signed download link. Limits: 1,000 rows, 25 columns, 4,096 bytes per cell, 10 MB per file. Call only after the user explicitly requests a file, CSV, spreadsheet, or download. Retrying with identical SQL within 15 minutes recovers the same export without charging again.
getDatasetContext
ChatGPT📚 Get dataset schema, business rules, and query guidelines. Call this once at the start of a conversation. Provides: - Full table schemas with column types and descriptions - Table relationships and optimal join patterns - Business rules (e.g., all monetary values in MILLIONS) - Common pitfalls and validation tips For SQL examples: Use getQueryExamples to get examples by category (Funding Analysis, Investor Analysis, People & Relationships, etc.)
getQueryExamples
ChatGPT📝 Get BigQuery example queries by category. WHEN RUNNING UNFAMILIAR QUERIES USE AS REFERENCE! Categories: - Funding Analysis: Deal lookups, unicorns, funding calculations - Investor Analysis: Portfolio queries, active investors, multi-entity firms - People & Relationships: Find people at companies, investment personnel - LinkedIn Work History: Past employers, education lookups - Industry Discovery & Filtering: Discover permalinks, filter by industry/super category, avoid cartesian products - Geographic Discovery & Filtering: Country/city/continent filtering patterns - Advanced Patterns: Founders with ARRAY_AGG, self-join valuations, multi-discovery synthesis - Date Filtering Patterns: Relative dates, specific date ranges - BigQuery Window Functions: ROW_NUMBER, QUALIFY patterns
getTableDetails
ChatGPTGet schema for a specific table
get_credit_balance
ChatGPTCheck the current Fundable credit balance and available purchase options. This tool does not use credits.
listDatasetTables
ChatGPTGet a quick list of available tables
previewData
ChatGPTExecute read-only BigQuery SQL queries as an inline preview against the VC dataset. Use this tool for analysis and lists, including requests for more than 15 rows; return at most 15 preview rows and explain that a downloadable export is available. Requests for a file, CSV, spreadsheet, download, or transferable dataset use exportData instead. Use previewData for bounded analysis and sampling only. It is subject to short-term request throttles and rolling row allowances. Do not paginate, loop, use offsets, or repeatedly query to reconstruct a larger dataset. Limits may be enforced without advance notice. Use exportData for bulk retrieval. This tool executes raw SQL queries. Without the dataset context, you're likely to: - Forget that values are in MILLIONS - Not understand how to avoid Cartesian-product joins - Understand when to use Canonical Deal IDs vs Deal IDs - Know how to handle SECONDARY_MARKET raises - How to handle date / timestamps in BigQuery Before querying: - Call getDatasetContext for schema and business rules - Call getQueryExamples with a category for SQL patterns Safety Features: - Automatic validation (no write operations allowed) - Cost control (default 15 rows, hard cap 15 rows, a 30,000-byte complete-response ceiling, and a BigQuery byte ceiling) - Per-user preview rate limits (bulk data belongs in exportData) - Query optimization suggestions - Helpful error messages with fixes Large non-file requests remain previews and do not silently become exports.
unlockPersonEmail
ChatGPTUnlock a verified email for a person. PAID ACTION: the first unlock for the account costs 5 credits; unlocking the same person again costs 0 credits. Before calling, obtain explicit user approval for this individual unlock or confirm it is covered by a clearly bounded batch or credit budget the user already authorized. Do not exceed the authorized scope.
unlockPersonEmails
ChatGPTUnlock verified emails for 1 to 20 people in one paid batch. PAID ACTION: this call can use up to maxCredits, with at most 5 credits used for each newly unlocked email and 0 credits for free outcomes. Before calling, obtain explicit user approval for exactly these people and this maxCredits ceiling. Submit the complete approved batch once; do not split it into repeated singular unlocks.
unlockPersonPhone
ChatGPTUnlock a verified phone for a person. PAID ACTION: the first unlock for the account costs 5 credits; unlocking the same person again costs 0 credits. Before calling, obtain explicit user approval for this individual unlock or confirm it is covered by a clearly bounded batch or credit budget the user already authorized. Do not exceed the authorized scope.
unlockPersonPhones
ChatGPTUnlock verified phone numbers for 1 to 20 people in one paid batch. PAID ACTION: this call can use up to maxCredits, with at most 5 credits used for each newly unlocked phone and 0 credits for free outcomes. Before calling, obtain explicit user approval for exactly these people and this maxCredits ceiling. Submit the complete approved batch once; do not split it into repeated singular unlocks.