KuzuDB Files

We’re delighted to announce the release of Kuzu 0.9.0, whose most notable feature is a new vector extension that allows you to perform similarity search over vector data fully within Kuzu. Other features include: - Arbitrary SQL scans from Postgres databases - WASM with bundled extensions - Async Python API and Sync Node.js API - Unity Catalog integration - MCP server implementation - G.V() integration

Besides new features, we've continuously improved the performance of our aggregation along with the creation of fts indexes a lot!

Please check our release post for more details.

What's Changed

• Add tests with different node group sizes + fix bugs by @royi-luo in https://github.com/kuzudb/kuzu/pull/4928
• Temporarily disable daily build until 0.8.2 release by @mewim in https://github.com/kuzudb/kuzu/pull/4950
• Fix list-predicate functions by @acquamarin in https://github.com/kuzudb/kuzu/pull/4947
• Implement hint for unnested subquery by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4955
• Refactor scalar_func_exec_t to take in separate selection vectors by @royi-luo in https://github.com/kuzudb/kuzu/pull/4948
• Revert "Temporarily disable daily build until 0.8.2 release" by @mewim in https://github.com/kuzudb/kuzu/pull/4956
• Refactor semi mask by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4940
• Skip inserting null keys into distinct hash tables by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/4949
• Fix compile warnings in function executors by @royi-luo in https://github.com/kuzudb/kuzu/pull/4960
• Optimize embedding caching in vector index construction by @ray6080 in https://github.com/kuzudb/kuzu/pull/4920
• Improve semi mask planning by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4957
• Optimize InMemHNSWGraph::getNeighbors by @ray6080 in https://github.com/kuzudb/kuzu/pull/4951
• Fix export database with official extension. by @acquamarin in https://github.com/kuzudb/kuzu/pull/4961
• Fix label predicate in recursive pattern by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4966
• Support EXISTS subquery in recursive pattern predicate by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4969
• Fix json output format in shell by @acquamarin in https://github.com/kuzudb/kuzu/pull/4968
• gds: init scc computation using kosaraju's algorithm by @sdht0 in https://github.com/kuzudb/kuzu/pull/4893
• Fix extend cardinality by @royi-luo in https://github.com/kuzudb/kuzu/pull/4843
• Parallel Distinct SimpleAggregate by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/4934
• Remove old recursive extend by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4976
• Reuse scan state for multiple table scans by @ray6080 in https://github.com/kuzudb/kuzu/pull/4975
• Support customized extension repo by @acquamarin in https://github.com/kuzudb/kuzu/pull/4973
• Support lambdas on lists with size > DEFAULT_VECTOR_CAPACITY by @royi-luo in https://github.com/kuzudb/kuzu/pull/4979
• Refactor parsed expr visitor by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4977
• Refactor DDL operator by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4984
• Fix Python build issue caused by shell_printer by @mewim in https://github.com/kuzudb/kuzu/pull/4985
• Support ignore_errors option for copy from subquery by @royi-luo in https://github.com/kuzudb/kuzu/pull/4988
• Update Kùzu to Kuzu for consistency with SEO discoverability by @prrao87 in https://github.com/kuzudb/kuzu/pull/4965
• Only merge distinct aggregate hash tables into the global queues when full by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/4972
• Fix hash 256 function by @acquamarin in https://github.com/kuzudb/kuzu/pull/4989
• Statistics update optimization by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/4980
• Fix deserialization of empty node groups by @royi-luo in https://github.com/kuzudb/kuzu/pull/4987
• Update CI workflow to use Debian 12 for code coverage job by @mewim in https://github.com/kuzudb/kuzu/pull/4996
• Refactor table scan state interfaces by @ray6080 in https://github.com/kuzudb/kuzu/pull/4981
• Fix json output mode with meta-data by @acquamarin in https://github.com/kuzudb/kuzu/pull/4993
• Fix json casting issue by @acquamarin in https://github.com/kuzudb/kuzu/pull/4992
• Selection vector slicing with lightweight SelectionView by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/4998
• Support gds optioanl args by @acquamarin in https://github.com/kuzudb/kuzu/pull/4999
• Add projected graph node filter by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/4990
• Split recursive join and gds at logical operator level by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5003
• Enable dynamic dispatch for simsimd by @royi-luo in https://github.com/kuzudb/kuzu/pull/5000
• Add is ready only field to function by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5002
• Add squared distance function for arrays by @royi-luo in https://github.com/kuzudb/kuzu/pull/5008
• Refactor gds frontier by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5006
• refactor: Kùzu -> Kuzu by @sdht0 in https://github.com/kuzudb/kuzu/pull/5005
• Tie rust QueryResult lifetime to that of the Database by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5009
• Implement SQL_QUERY function by @acquamarin in https://github.com/kuzudb/kuzu/pull/5010
• Fix nested decimal type casting by @acquamarin in https://github.com/kuzudb/kuzu/pull/5018
• Split recursive extend and gds at binding level by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5020
• Added rustdoc example for Connection::execute by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5022
• Try to fix CI workflow for forked repo by @mewim in https://github.com/kuzudb/kuzu/pull/5027
• Implement copy from table function by @acquamarin in https://github.com/kuzudb/kuzu/pull/5023
• Split rec join and gds at physical level by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5021
• Refactor gds output writer by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5028
• gds: init parallel scc by @sdht0 in https://github.com/kuzudb/kuzu/pull/5011
• Hide columns in table func bind data by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5029
• Disable compression on floating point values in array/list by @ray6080 in https://github.com/kuzudb/kuzu/pull/5035
• Separate SemiMask interface and implementation by @ray6080 in https://github.com/kuzudb/kuzu/pull/5036
• Implement parameter casting for table functions by @acquamarin in https://github.com/kuzudb/kuzu/pull/5034
• Fix incorrect src dst for undirected path by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5041
• Revert "Try to fix CI workflow for forked repo" by @mewim in https://github.com/kuzudb/kuzu/pull/5043
• Expose semi mask sub-plan in the logical plan tree by @ray6080 in https://github.com/kuzudb/kuzu/pull/5037
• Swap tableName and indexName in hnsw functions by @ray6080 in https://github.com/kuzudb/kuzu/pull/5038
• Allow loading from multiple files by @ray6080 in https://github.com/kuzudb/kuzu/pull/5045
• Remove cardinality from tableFuncBindData by @acquamarin in https://github.com/kuzudb/kuzu/pull/5039
• Refactor table function by @acquamarin in https://github.com/kuzudb/kuzu/pull/5046
• Support handling null/deleted nodes during vector index creation by @royi-luo in https://github.com/kuzudb/kuzu/pull/5014
• Improve SelectionVector::fromValueVectors by @ray6080 in https://github.com/kuzudb/kuzu/pull/5052
• Make QueryResult::toString const by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5013
• Make GDS table function by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5048
• Change hnsw input parameter types by @acquamarin in https://github.com/kuzudb/kuzu/pull/5042
• Use copyNullMask instead of looping during copies of nulls by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5015
• Implement multi-labeled wcc by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5057
• Implement synchronous APIs for Node.js bindings by @mewim in https://github.com/kuzudb/kuzu/pull/5058
• Multi label page rank by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5060
• Use correct offset to access vector index embeddings during creation by @royi-luo in https://github.com/kuzudb/kuzu/pull/5063
• Add AsyncConnection for asynchronous query execution on Python API by @mewim in https://github.com/kuzudb/kuzu/pull/5061
• Clear table function signatures by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5059
• Filtered HNSW search by @ray6080 in https://github.com/kuzudb/kuzu/pull/5019
• Unify vector index, gds & table function planning by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5067
• Implement internal_id function to create internal_id literal by @acquamarin in https://github.com/kuzudb/kuzu/pull/5071
• Throw exception when extension rewrite functions called in a multi-statement query by @acquamarin in https://github.com/kuzudb/kuzu/pull/5072
• Add job for testing simsimd dynamic dispatch to nightly build-and-deploy workflow by @royi-luo in https://github.com/kuzudb/kuzu/pull/5007
• Vector extension by @ray6080 in https://github.com/kuzudb/kuzu/pull/5047
• Add option blind/directed upper sel threshold; rename distFunc to metric by @ray6080 in https://github.com/kuzudb/kuzu/pull/5069
• Move OutputNodeMask output GDSComputeState by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5077
• Optimize regex match execution by @acquamarin in https://github.com/kuzudb/kuzu/pull/5079
• Add projected graph with table droping tests by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5073
• Rename hnsw functions by @ray6080 in https://github.com/kuzudb/kuzu/pull/5078
• Support yield for QUERY_VECTOR_INDEX by @ray6080 in https://github.com/kuzudb/kuzu/pull/5084
• Update nightly simd dispatch test by @royi-luo in https://github.com/kuzudb/kuzu/pull/5083
• Add support for transforming arrays and objects parameters for WASM by @mewim in https://github.com/kuzudb/kuzu/pull/5088
• fixed cli highlighting utf8 issue by @MSebanc in https://github.com/kuzudb/kuzu/pull/5087
• Fix missing chrono include that prevents windows builds by @Robert-W-Ward in https://github.com/kuzudb/kuzu/pull/5089
• Add windows 2025 to multiplatform test by @mewim in https://github.com/kuzudb/kuzu/pull/5090
• Zero new memory after resizing ColumnChunkData by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5082
• Fix setDstNode in shrink by @ray6080 in https://github.com/kuzudb/kuzu/pull/5092
• Distinct Aggregate vectorization by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5031
• Make Python API queries interruptable by @royi-luo in https://github.com/kuzudb/kuzu/pull/5094
• Fix incorrectly resized chunkStates in local scan state by @ray6080 in https://github.com/kuzudb/kuzu/pull/5095
• Shell table autocomplete catalog version by @MSebanc in https://github.com/kuzudb/kuzu/pull/5091
• Make EXTENSION keyword optional in LOAD EXTENSION statement by @ray6080 in https://github.com/kuzudb/kuzu/pull/5098
• Avoid project constant expression in WITH by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5099
• Add function alias for compatibility by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5103
• Fix contention in re2 expression by @acquamarin in https://github.com/kuzudb/kuzu/pull/5104
• Fix unused member compile warnings by @royi-luo in https://github.com/kuzudb/kuzu/pull/5110
• Implement extension static linking by @acquamarin in https://github.com/kuzudb/kuzu/pull/5093
• Fix list lambda collector by @acquamarin in https://github.com/kuzudb/kuzu/pull/5112
• Add function alias by @acquamarin in https://github.com/kuzudb/kuzu/pull/5115
• Fix hang in JSON parsing when error is hit with ignore errors false by @royi-luo in https://github.com/kuzudb/kuzu/pull/5108
• Fix bug in reloadDB test command by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5113
• Fix function names in show_function() by @acquamarin in https://github.com/kuzudb/kuzu/pull/5116
• Fix c api parameter binding by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5117
• Fix rel group replay by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5114
• Allow WAL replaying on some corrupted WAL files (e.g. after DB was killed) by @royi-luo in https://github.com/kuzudb/kuzu/pull/5111
• Disable parallel copy of vectors in vector extension tests by @ray6080 in https://github.com/kuzudb/kuzu/pull/5096
• Track hash index memory usage by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5074
• Fix size of chunks in RelBatchInsert by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5119
• Fix projection push down for sql_query function by @acquamarin in https://github.com/kuzudb/kuzu/pull/5122
• Rename the default return variable _distance to distance in QueryVectorIndex by @ray6080 in https://github.com/kuzudb/kuzu/pull/5109
• Fix concurrency issue in building hnsw by @ray6080 in https://github.com/kuzudb/kuzu/pull/5121
• Make yield as non-reserved keyword by @acquamarin in https://github.com/kuzudb/kuzu/pull/5125
• Validate projected graph argument type by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5124
• Fix dropping table with fts and vector indexes by @ray6080 in https://github.com/kuzudb/kuzu/pull/5131
• Fix resetting index entry's aux info when it was loaded already by @ray6080 in https://github.com/kuzudb/kuzu/pull/5129
• Add value checks on mu, ml and k by @ray6080 in https://github.com/kuzudb/kuzu/pull/5130
• Fix array size by @acquamarin in https://github.com/kuzudb/kuzu/pull/5135
• Implement show_projected_graph function by @acquamarin in https://github.com/kuzudb/kuzu/pull/5134
• Remove duplicated YIELD definition by @mewim in https://github.com/kuzudb/kuzu/pull/5143
• Migrate code coverage job to self-hosted runner by @mewim in https://github.com/kuzudb/kuzu/pull/5144
• Error when default expression type doesn't match by @acquamarin in https://github.com/kuzudb/kuzu/pull/5137
• Add mnist dataset by @ray6080 in https://github.com/kuzudb/kuzu/pull/5148
• Allow same index name on different tables by @ray6080 in https://github.com/kuzudb/kuzu/pull/5146
• Add static link extensions for WASM and Android NDK builds by @mewim in https://github.com/kuzudb/kuzu/pull/5147
• Add demo example in docs to codebase by @ray6080 in https://github.com/kuzudb/kuzu/pull/5149
• Rename return variable of QueryVectorIndex from nn to node by @ray6080 in https://github.com/kuzudb/kuzu/pull/5145
• Rename show_projected_graph to show_projected_graphs by @ray6080 in https://github.com/kuzudb/kuzu/pull/5140
• Improve regexp_replace performance by @acquamarin in https://github.com/kuzudb/kuzu/pull/5151
• Skip WASM UDTInvalidCast test case by @mewim in https://github.com/kuzudb/kuzu/pull/5153
• Add click benchmarks by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5154
• Fix copy dataframes to multi-nodes pair rel table bug by @acquamarin in https://github.com/kuzudb/kuzu/pull/5165
• Fix empty list check by @andyfengHKU in https://github.com/kuzudb/kuzu/pull/5166
• Fix rust extensions in testing and document how other binaries can use them by @benjaminwinger in https://github.com/kuzudb/kuzu/pull/5138
• Change max line length to 65536 for shell and fix Android static link by @mewim in https://github.com/kuzudb/kuzu/pull/5168
• Bump version to 0.9.0 by @mewim in https://github.com/kuzudb/kuzu/pull/5174

New Contributors

• @Robert-W-Ward made their first contribution in https://github.com/kuzudb/kuzu/pull/5089

Full Changelog: https://github.com/kuzudb/kuzu/compare/v0.8.1...v0.9.0