Connecting databases

Insight O' Mate supports MongoDB, Redis, Firestore, DynamoDB, and Excel/CSV Spreadsheets. Connection strings and spreadsheet data remain local on your machine. They never leave your machine.

A read-only role or policy is strongly recommended for all database types to ensure your data cannot be mutated.

Choose a data source below for specific connection details, role setup, and inference behavior:

• MongoDB
• Redis
• Firestore
• DynamoDB
• Excel & Spreadsheets

Troubleshooting

• Mongo "connection timed out": Check your IP access list in Atlas or bindIp for self-hosted.
• Redis "Authentication failed": Check your ACL rules or password in the URI.
• DynamoDB "AccessDeniedException": Ensure the IAM user has dynamodb:ListTables and dynamodb:Scan permissions for the target region.
• Excel "No tabular data found": Ensure each sheet contains a clear header row with column names and at least one data row.