Q: How integrated with AI are you?
1. Can I compile a website database? - Create structured data within your application for each record, whilst adhering to a db schema (data type + constraints)? IE, loop through rows in a single column (car models). Send API request per row to an external web scraping service and map results to column.
2. Am I able to transform data (standardize records)?
3. Am I able to create custom automations?
4. Can I perform RAG with tables? IE, SQL like rag chains, where I request info that requires the LLM to perform an SQL query, and then return answer based on results from SQL query.
5. What about using variables (column names) for LLM content creation? For example, 'Use the information from column 2 (format) to create a poem for column 1 (subject) in this language (column 11)'
6. Is your db relational with 'lookup fields' like foreign keys?
KelvinJW
Mar 19, 2025A: 1. Compiling a Website Database：
It's not entirely clear what you mean by "compile a website database", but in bika.ai, the Database as a structured spreadsheet. This means you can use it to manage and organize data effectively. For example, the scenario you described—looping through rows in a column (e.g., car models), sending API requests to an external web scraping service, and mapping the results back into the table—is achievable using Bika's open API.
2. Transforming Data (Standardizing Records)
Could you clarify the specific transformation you're referring to? For instance, are you looking to convert data types (e.g., text to numbers) or perform text standardization? If you can share more about your use case, we'd be happy to guide you further.
3. Creating Custom Automations
Absolutely! Automation is a core feature of bika.ai. you can design and implement custom workflows tailored to your specific needs.
4. Performing RAG with Tables：
While bika.ai doesn't support SQL queries directly, you can use our open API to retrieve records from your tables and then feed them into external RAG software for vectorization and further processing. This approach allows you to integrate RAG functionality seamlessly.
5. Using Variables for LLM Content Creation
Yes, this is possible! We recently introduced a new field type called "AI Text". Using this, you can reference other columns as variables to dynamically construct an LLM prompt. Once configured, simply click the "Generate" button to create content using the LLM based on the specified variables.
6. Relational Database with Lookup Fields：
Essentially, yes. bika.ai supports linking tables using "Link Field", which allow you to establish relationships between tables. Additionally, you can use "Lookup Field" to map data from one table to another