Is there a place in the docs that lists SQL clients and tools for Citus?

[Abdullah Kaya (kaya-abdullah)]

Hi, we maintain LibreDB Studio, an open source (MIT) web-based SQL IDE: https://github.com/libredb/libredb-studio

It connects to the Citus coordinator through its PostgreSQL driver, and we have tested it against Citus 14.1 on PostgreSQL 18. The citus_tables and citus_schemas views show up in its object browser next to the user tables.

The Integrations page in the docs (https://docs.citusdata.com/en/stable/develop/integrations.html) covers Kafka, Spark and Tableau, but we could not find a place that lists SQL clients and database tools for Citus. Is there one we missed, or would you be open to adding LibreDB Studio somewhere? We noticed that recent PRs to citus_docs were closed with "added to the new docs", so it would help to know where such a change should go now.

Thanks.

[ibrahim halatci (ihalatci)]

New home of the docs is http://learn.microsoft.com/postgresql/citus
Feel free to propose updates through the learn.

[Abdullah Kaya (kaya-abdullah)]

Thanks ibrahim halatci (@ihalatci). The Edit link on that page points to MicrosoftDocs/azure-databases-docs, which is no longer public, so we cannot open a pull request there. Since you maintain these pages, would you consider adding a short section to the Integrations page? Here is a suggested text:

SQL clients

Connect any PostgreSQL client to the coordinator node. For example, LibreDB Studio, an open source web-based SQL IDE, connects through its PostgreSQL connection and shows the citus_tables and citus_schemas views in its object browser next to the user tables.

Happy to adjust the wording.

[Mehmet Cevheri BOZOGLAN (cevheri)]

thanks Abdullah Kaya (@kaya-abdullah) for your update
ibrahim halatci (@ihalatci) is this page available with github PR or another contributing way ?

[Mehmet Cevheri BOZOGLAN (cevheri)]

[Yusuf Gündoğdu (yusuf-gundogdu)]

Thanks, that settles where the content lives. The Integrations page is now at https://learn.microsoft.com/en-us/postgresql/citus/integrations, and it still covers CDC, Kafka, Spark and Tableau with nothing on SQL clients.

What we cannot get past is the route rather than the page. That article carries github_feedback_content_git_url = https://github.com/MicrosoftDocs/azure-databases-docs/blob/main/citus/integrations.md, and GitHub answers 404 for the repository itself, not only for the file, so there is nothing to fork or branch from. Its original_content_git_url points at MicrosoftDocs/azure-databases-docs-pr, which is the internal mirror. The two other links the page offers, the Microsoft Q&A tag azure-database-postgresql and the Azure feedback forum, lead to product support, and neither one edits the article.

So as far as we can tell, proposing an update through Learn has no public entry point today. If one exists that we have missed, point us at it and we will use it. If there is none, would you add this under a new heading yourself?

SQL clients

Any PostgreSQL client connects to the coordinator node. For example LibreDB Studio, an open source web-based SQL IDE, connects through its PostgreSQL connection and lists the citus_tables and citus_schemas views in its object browser next to the user tables. Tested against Citus 14.1 on PostgreSQL 18.