Skip to main contentResources are your connected data sources in Ledgerbeam. They represent databases, spreadsheets, APIs, and other business tools that you want to query using natural language.
What Are Resources?
A resource is a connection to a data source that Ledgerbeam can query. When you create a resource, Ledgerbeam analyzes the data structure, understands the schema, and makes it available for conversational queries.
Supported Resource Types
Databases
Connect to relational databases to query structured data:
- PostgreSQL - Full support for PostgreSQL databases
- MySQL - Connect to MySQL and MariaDB databases
- Supabase - Connect to Supabase projects
- MongoDB - Connect to MongoDB databases
- Oracle - Connect to Oracle databases
Spreadsheets
Query spreadsheet data directly:
Integrate with popular business applications:
- Stripe - Query payment and subscription data
- Airtable - Connect to Airtable bases
- Intercom - Connect to Intercom for customer data
APIs
Connect to REST and GraphQL APIs:
Search & Caching
Connect to search engines and caching systems:
Google Services
Integrate with Google Workspace:
Resource Lifecycle
Creating Resources
When you create a resource, Ledgerbeam:
- Validates the connection credentials
- Analyzes the data structure and schema
- Identifies tables, columns, and relationships
- Makes the resource available for queries
Schema Analysis
Ledgerbeam automatically analyzes your data structure to understand:
- Tables and their relationships
- Column names, types, and constraints
- Primary and foreign keys
- Data patterns and sample values
Resyncing Resources
If your data structure changes, you can resync a resource to update Ledgerbeam’s understanding of your schema.
Security
Credential Management
- Credentials are encrypted and stored securely
- Passwords are never exposed in API responses
- Connections use encrypted protocols (SSL/TLS)
Access Control
- Resources are scoped to your organization
- Only authorized team members can access resources
- API keys control access to resources
Container Management
Resources contain containers (tables, sheets, etc.) that hold your data. You can:
- List all containers in a resource
- Get detailed information about specific containers
- Update container metadata and descriptions
- Manage fields within containers
Field Configuration
For each field in your containers, you can:
- Set semantic types (e.g., “email”, “currency”, “date”)
- Configure possible values for categorical data
- Add descriptions to help the AI understand your data better
Getting Started
Ready to connect your first data source? Check out our API Reference for detailed endpoint documentation, or see our Quick Start Guide to connect a resource in minutes.