Use a SQLite database with Claude.
SQLite is a file, not a remote server. Loam imports an uploaded .sqlite, .sqlite3, or .db file into a governed Loam table. Data Connector then gives Claude read-only access to that table through the same workspace permissions.
1. Import SQLite into Loam
Sign in or sign up with Loam, open a writable Dataset, choose Add table, and upload your SQLite file. The Loam web upload accepts files up to 100 MB. Loam previews the database catalog so you can select the exact source table before import. The upload is staged as authenticated bytes. Server paths and arbitrary file URLs are never accepted.
2. Connect Data Connector MCP
Add this remote MCP server in Claude:
https://dataconnector.ai/api/mcpAuthorize the same Loam workspace that contains the imported table.
3. Ask Claude to inspect the table
Start with: List my Loam tables, describe the imported table, then show me five example rows. Claude uses the bounded list_tables, describe_table, and execute_sql_query tools.
Security boundary
The original SQLite file is not opened from an arbitrary filesystem location. Import decoding uses bounded parser, row, column, and byte limits. MCP queries continue through Loam's workspace permissions and read-only SQL policy.
Frequently asked questions
Can Claude open a local SQLite path through Data Connector?
No. Upload the SQLite file to Loam through the authenticated Dataset flow. Data Connector never accepts a server path or arbitrary file URL.
What if my SQLite database has several tables?
Loam previews the catalog and asks you to choose one source table for each import.
Which SQLite files can I upload?
Loam accepts .sqlite, .sqlite3, and .db files up to 100 MB through the web import flow.