v1.0.0

What's Changed

• (fix) refresh table and ner adjustment by @akbar-mta in #50
• (feat) endpoint for retrieving similar context stores by @akbar-mta in #51
• (feat) SQL to CSV and ollama embeddings by @akbar-mta in #52
• (fix) edge case SQL with same column name by @akbar-mta in #53
• Development by @theodevmta in #54
• PR Bug Fixing by @mta-edi-sugiarto in #55
• Feat/table description by @akbar-mta in #56
• Added several features by @mta-edi-sugiarto in #57
• Feat/alias-module by @mta-edi-sugiarto in #58
• Feat/alias module by @mta-edi-sugiarto in #59
• Refactor/sql agent graph by @akbar-mta in #60
• Feat/synthetic question by @akbar-mta in #61
• Development by @mta-edi-sugiarto in #62
• (bug) fix distinct value on table description by @malpr in #63
• (fix) parsing error on query by @malpr in #64
• (fix) typesense error when retrieve distinct value by @malpr in #65
• Disable duplicate alias name check for alias creation by @mta-edi-sugiarto in #66
• Manage database connections and dispose on shutdown by @mta-edi-sugiarto in #67
• feat(sql-generation): add endpoint to stream sql results to gcs by @mta-edi-sugiarto in #68
• feat(sql_generation): implement retries for GCS file uploads by @mta-edi-sugiarto in #69
• fix(sql_database): gracefully handle empty or unserializable query by @mta-edi-sugiarto in #70
• feat(kai-v1): major refactor with LangGraph integration and new modules by @rebekz in #71

New Contributors

• @malpr made their first contribution in #63

Full Changelog: v0.2.0...v1.0.0

v0.2.0

Features:

• Added NER Capabilities
• Added automatic table descriptions
• Added automatic column descriptions
• Added load csv functionality
• Added capability to use google chat models
• Added capability to use openrouter chat models
• Added capability to use google embedding models
• Added capability to initiate embedding with various dimensions
• Added modularity to RAG service
• Added option text2sql with developmental features
• Added execution timing duration
• Added assumption to use public schemas if not explicitly defined
• Added delete DB connection endpoint

Fixes:

• Fixed bugs in tools calling DBColumnEntityChecker
• Fixed bugs in empty instruction to be processed
• Fixed fewshot prompt to not always get admin instruction if not found
• Minor fix SqlDbQuery tools
• Minor fix metadata in SQL generation to append from request

Contributors:
@theodevmta @akbar-mta @mta-edi-sugiarto

v0.1.0

We are excited to announce KAI 0.1, the first release of the KAI open-source project!

Credits

This release has been made possible by @theodevmta and @mta-edi-sugiarto. Thank you for making this release possible.