feat(sources/Cassandra): add support for Cassandra #1012

bpranava · 2025-07-27T18:52:04Z

Cassandra is a NoSQL distributed database. By design, NoSQL databases are lightweight, open-source, non-relational, and largely distributed. Counted among their strengths are horizontal scalability, distributed architectures, and a flexible approach to schema definition.

Cassandra go driver link - https://pkg.go.dev/github.com/apache/cassandra-gocql-driver/v2

This PR

adds a new source for cassandra
adds a new tool cassandra-cql with support for executing predefined parameterized CQL queries on cassandra
adds unit and integration tests for the tool and the source
adds documentation for the cassandra source and cassandra-cql tool

duwenxin99 · 2025-07-31T02:43:21Z

Hi @bpranava, thanks for opening a PR! We have received many feature requests recently so there may be a delay in reviews. But we will try our best to get to it ASAP!

SleeperSmith · 2025-08-10T06:48:35Z

@duwenxin99 I need the cassandra support quite urgently so I thought I'd have a look into why the test failed. But it seems like the details are locked behind google cloud build? Any chance of either opening that up or getting someone to have a look into it?

Thanks in advance.

duwenxin99 · 2025-08-11T21:17:57Z

/gcbrun

internal/sources/cassandra/cassandra_test.go

internal/tools/cassandra/cassandracql/cassandracql_test.go

tests/cassandra/cassandra_integration_test.go

duwenxin99 · 2025-08-11T23:18:58Z

Hi @bpranava, I left a review for a few small changes and other than these LGTM. Please rebase on the latest main and I'll set up an integration test instance. Again thanks for the contribution!

duwenxin99 · 2025-08-11T23:22:23Z

@duwenxin99 I need the cassandra support quite urgently so I thought I'd have a look into why the test failed. But it seems like the details are locked behind google cloud build? Any chance of either opening that up or getting someone to have a look into it?

Thanks in advance.

Hi @SleeperSmith, currently the test is failing on Cloud Build because we haven't set up a testing instance yet. I just left reviews and will set up testings shortly. You could also connect to your own instance and try to run the tests locally to check for any errors while waiting. Thanks for your patience!

bpranava · 2025-08-12T01:37:07Z

@duwenxin99 I need the cassandra support quite urgently so I thought I'd have a look into why the test failed. But it seems like the details are locked behind google cloud build? Any chance of either opening that up or getting someone to have a look into it?
Thanks in advance.

Hi @SleeperSmith, currently the test is failing on Cloud Build because we haven't set up a testing instance yet. I just left reviews and will set up testings shortly. You could also connect to your own instance and try to run the tests locally to check for any errors while waiting. Thanks for your patience!

I have verified the integration tests with a local singlenode cassandra instance, let me know if there are any issues. Thanks!

duwenxin99 · 2025-08-13T22:38:46Z

/gcbrun

bpranava · 2025-08-20T10:29:04Z

Hi @duwenxin99, any update on this?

duwenxin99 · 2025-08-20T18:51:57Z

Hi @bpranava, is there any reason why Cassandra can't use the generic test functions (e.g. tests.RunToolInvokeTest)?

duwenxin99 · 2025-09-09T15:02:40Z

Hi @bpranava, a gentle ping here: are you still interested in contributing to the Cassandra integration?

bpranava · 2025-09-23T03:39:14Z

Hi @bpranava, I took some time to fix the test setup and now it is passing. Just one final nit on the authentication. Let me know when you update and are ready to merge it. Thank you!

@duwenxin99 thanks for your patience and for taking the time to fix the test setup. I have addressed the review comment regarding authentication

duwenxin99 · 2025-09-23T18:39:33Z

/gcbrun

github-actions · 2025-09-23T20:38:26Z

🔎 Preview at https://googleapis.github.io/genai-toolbox/previews/PR-1012/

[Cassandra](https://cassandra.apache.org/_/cassandra-basics.html) is a NoSQL distributed database. By design, NoSQL databases are lightweight, open-source, non-relational, and largely distributed. Counted among their strengths are horizontal scalability, distributed architectures, and a flexible approach to schema definition. Cassandra go driver link - https://pkg.go.dev/github.com/apache/cassandra-gocql-driver/v2 This PR - adds a new source for cassandra - adds a new tool _cassandra-cql_ with support for executing predefined parameterized CQL queries on cassandra - adds unit and integration tests for the tool and the source - adds documentation for the cassandra source and cassandra-cql tool --------- Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> Co-authored-by: duwenxin <duwenxin@google.com> 6e42053

duwenxin99 · 2025-09-23T20:55:59Z

@bpranava merged. Thanks for the contribution!

🤖 I have created a release *beep* *boop* --- ## [0.16.0](v0.15.0...v0.16.0) (2025-09-25) ### ⚠ BREAKING CHANGES * **tool/bigquery-execute-sql:** add allowed datasets support ([#1443](#1443)) * **tool/bigquery-forecast:** add allowed datasets support ([#1412](#1412)) ### Features * **cassandra:** Add Cassandra Source and Tool ([#1012](#1012)) ([6e42053](6e42053)) * **sources/postgres:** Add application_name ([#1504](#1504)) ([72a2366](72a2366)) * **tool/bigquery-execute-sql:** Add allowed datasets support ([#1443](#1443)) ([9501ebb](9501ebb)) * **tool/bigquery-forecast:** Add allowed datasets support ([#1412](#1412)) ([88bac7e](88bac7e)) * **tools/clickhouse-list-tables:** Add list-tables tool ([#1446](#1446)) ([69a3caf](69a3caf)) ### Bug Fixes * **tool/mongodb-find:** Fix find tool `limit` field ([#1570](#1570)) ([4166bf7](4166bf7)) * **tools/mongodb:** Concat filter params only once in mongodb update tools ([#1545](#1545)) ([295f9dc](295f9dc)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). --------- Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com> Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>

🤖 I have created a release *beep* *boop* --- ## [0.16.0](v0.15.0...v0.16.0) (2025-09-25) ### ⚠ BREAKING CHANGES * **tool/bigquery-execute-sql:** add allowed datasets support ([#1443](#1443)) * **tool/bigquery-forecast:** add allowed datasets support ([#1412](#1412)) ### Features * **cassandra:** Add Cassandra Source and Tool ([#1012](#1012)) ([6e42053](6e42053)) * **sources/postgres:** Add application_name ([#1504](#1504)) ([72a2366](72a2366)) * **tool/bigquery-execute-sql:** Add allowed datasets support ([#1443](#1443)) ([9501ebb](9501ebb)) * **tool/bigquery-forecast:** Add allowed datasets support ([#1412](#1412)) ([88bac7e](88bac7e)) * **tools/clickhouse-list-tables:** Add list-tables tool ([#1446](#1446)) ([69a3caf](69a3caf)) ### Bug Fixes * **tool/mongodb-find:** Fix find tool `limit` field ([#1570](#1570)) ([4166bf7](4166bf7)) * **tools/mongodb:** Concat filter params only once in mongodb update tools ([#1545](#1545)) ([295f9dc](295f9dc)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). --------- Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com> Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 964a82e

🤖 I have created a release *beep* *boop* --- ## [0.16.0](googleapis/genai-toolbox@v0.15.0...v0.16.0) (2025-09-25) ### ⚠ BREAKING CHANGES * **tool/bigquery-execute-sql:** add allowed datasets support ([googleapis#1443](googleapis#1443)) * **tool/bigquery-forecast:** add allowed datasets support ([googleapis#1412](googleapis#1412)) ### Features * **cassandra:** Add Cassandra Source and Tool ([googleapis#1012](googleapis#1012)) ([6e42053](googleapis@6e42053)) * **sources/postgres:** Add application_name ([googleapis#1504](googleapis#1504)) ([72a2366](googleapis@72a2366)) * **tool/bigquery-execute-sql:** Add allowed datasets support ([googleapis#1443](googleapis#1443)) ([9501ebb](googleapis@9501ebb)) * **tool/bigquery-forecast:** Add allowed datasets support ([googleapis#1412](googleapis#1412)) ([88bac7e](googleapis@88bac7e)) * **tools/clickhouse-list-tables:** Add list-tables tool ([googleapis#1446](googleapis#1446)) ([69a3caf](googleapis@69a3caf)) ### Bug Fixes * **tool/mongodb-find:** Fix find tool `limit` field ([googleapis#1570](googleapis#1570)) ([4166bf7](googleapis@4166bf7)) * **tools/mongodb:** Concat filter params only once in mongodb update tools ([googleapis#1545](googleapis#1545)) ([295f9dc](googleapis@295f9dc)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). --------- Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com> Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com> 964a82e

[Cassandra](https://cassandra.apache.org/_/cassandra-basics.html) is a NoSQL distributed database. By design, NoSQL databases are lightweight, open-source, non-relational, and largely distributed. Counted among their strengths are horizontal scalability, distributed architectures, and a flexible approach to schema definition. Cassandra go driver link - https://pkg.go.dev/github.com/apache/cassandra-gocql-driver/v2 This PR - adds a new source for cassandra - adds a new tool _cassandra-cql_ with support for executing predefined parameterized CQL queries on cassandra - adds unit and integration tests for the tool and the source - adds documentation for the cassandra source and cassandra-cql tool --------- Co-authored-by: Wenxin Du <117315983+duwenxin99@users.noreply.github.com> Co-authored-by: duwenxin <duwenxin@google.com>

🤖 I have created a release *beep* *boop* --- ## [0.16.0](v0.15.0...v0.16.0) (2025-09-25) ### ⚠ BREAKING CHANGES * **tool/bigquery-execute-sql:** add allowed datasets support ([#1443](#1443)) * **tool/bigquery-forecast:** add allowed datasets support ([#1412](#1412)) ### Features * **cassandra:** Add Cassandra Source and Tool ([#1012](#1012)) ([6e42053](6e42053)) * **sources/postgres:** Add application_name ([#1504](#1504)) ([72a2366](72a2366)) * **tool/bigquery-execute-sql:** Add allowed datasets support ([#1443](#1443)) ([9501ebb](9501ebb)) * **tool/bigquery-forecast:** Add allowed datasets support ([#1412](#1412)) ([88bac7e](88bac7e)) * **tools/clickhouse-list-tables:** Add list-tables tool ([#1446](#1446)) ([69a3caf](69a3caf)) ### Bug Fixes * **tool/mongodb-find:** Fix find tool `limit` field ([#1570](#1570)) ([4166bf7](4166bf7)) * **tools/mongodb:** Concat filter params only once in mongodb update tools ([#1545](#1545)) ([295f9dc](295f9dc)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). --------- Co-authored-by: release-please[bot] <55107282+release-please[bot]@users.noreply.github.com> Co-authored-by: Yuan Teoh <45984206+Yuan325@users.noreply.github.com>

bpranava added 4 commits July 26, 2025 01:33

feat: add support for Cassandra

910b1a4

cassandra source and tool unit tests

bdf6eff

add cassandra template param integration tests

1ebb693

cassandra source and tool documentation

ea2d14a

bpranava requested a review from a team as a code owner July 27, 2025 18:52

blunderbuss-gcf bot assigned duwenxin99 Jul 27, 2025

add google copyright comments

e1f74a4

bpranava changed the title ~~feat: add support for Cassandra~~ feat(sources/Cassandra): add support for Cassandra Jul 31, 2025

bpranava added 2 commits August 6, 2025 20:24

Merge branch 'main' into feat/cassandra

7429f22

update docs

20f993d

bpranava added 3 commits August 10, 2025 13:23

Merge branch 'main' into feat/cassandra

b91d9e8

add auth service tests

5bcd870

add cloudbuild env args

2e80361

duwenxin99 requested changes Aug 11, 2025

View reviewed changes

internal/sources/cassandra/cassandra_test.go Show resolved Hide resolved

internal/tools/cassandra/cassandracql/cassandracql_test.go Show resolved Hide resolved

tests/cassandra/cassandra_integration_test.go Outdated Show resolved Hide resolved

bpranava added 3 commits August 12, 2025 06:33

address review comments

135b14a

run go mod tidy

cd91a3a

Merge branch 'main' into feat/cassandra

d2fe094

bpranava force-pushed the feat/cassandra branch from 2715969 to d2fe094 Compare August 12, 2025 01:10

bpranava requested a review from duwenxin99 August 12, 2025 01:12

update docs about port configurations

8f2711f

bpranava added 3 commits September 23, 2025 08:54

address authentication review comment

a2741ba

run golangci lint

ba27060

remove comment

e340127

Merge branch 'main' into feat/cassandra

f999e8f

duwenxin99 added the tests: run Label to trigger Github Action tests. label Sep 23, 2025

github-actions bot removed tests: run Label to trigger Github Action tests. labels Sep 23, 2025

duwenxin99 added docs: deploy-preview Label to trigger Github Action docs preview. tests: run Label to trigger Github Action tests. labels Sep 23, 2025

github-actions bot removed the tests: run Label to trigger Github Action tests. label Sep 23, 2025

duwenxin99 enabled auto-merge (squash) September 23, 2025 20:38

duwenxin99 merged commit 6e42053 into googleapis:main Sep 23, 2025
23 checks passed

release-please bot mentioned this pull request Sep 23, 2025

chore(main): release 0.16.0 #1530

Merged

BrewTestBot mentioned this pull request Sep 26, 2025

mcp-toolbox 0.16.0 Homebrew/homebrew-core#245761

Merged

This was referenced Sep 26, 2025

[source] Add source/tool for Cassandra #1263

Closed

feat: Support for Cassandra as a source #1264

Closed

release-please bot mentioned this pull request Nov 7, 2025

chore(main): release 0.19.1 #1901

Merged

feat(sources/Cassandra): add support for Cassandra #1012

feat(sources/Cassandra): add support for Cassandra #1012

Uh oh!

Conversation

bpranava commented Jul 27, 2025

Uh oh!

duwenxin99 commented Jul 31, 2025

Uh oh!

SleeperSmith commented Aug 10, 2025

Uh oh!

duwenxin99 commented Aug 11, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

duwenxin99 commented Aug 11, 2025

Uh oh!

duwenxin99 commented Aug 11, 2025

Uh oh!

bpranava commented Aug 12, 2025

Uh oh!

duwenxin99 commented Aug 13, 2025

Uh oh!

bpranava commented Aug 20, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

duwenxin99 commented Aug 20, 2025

Uh oh!

duwenxin99 commented Sep 9, 2025

Uh oh!

bpranava commented Sep 23, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

duwenxin99 commented Sep 23, 2025

Uh oh!

github-actions bot commented Sep 23, 2025

Uh oh!

Uh oh!

duwenxin99 commented Sep 23, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

bpranava commented Aug 20, 2025 •

edited

Loading

bpranava commented Sep 23, 2025 •

edited

Loading