microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

[Feature] ClickHouse support #22909

Open Slach opened 1 year ago

Slach commented 1 year ago

Is your feature request related to a problem? Please describe. I have Azure SQL and ClickHouse and need tool which could explore both tools

Describe the solution or feature you'd like Add ClickHouse support to Azure Data Studio

Describe alternatives you've considered Connect to ClickHouse via MySQL or PostgreSQL protocol

alanrenmsft commented 1 year ago

@Slach We do have extensions for MySQL and PGSQL, have you tried them?

image

image

Slach commented 1 year ago

ClickHouse support MySQL \ PostgreSQL protocols, but not support MySQL, PostgreSQL dialects

after connection for MySQL see a lot of errors like and can't explore schema

Traceback (most recent call last):
  File "mysql\connector\connection_cext.py", line 565, in cmd_query
_mysql_connector.MySQLInterfaceError: Code: 62. DB::Exception: Syntax error: failed at position 133 ('""') (line 2, col 80): "". Expected one of: CAST operator, ANY, ALL, NOT, INTERVAL, CASE, DATE, TIMESTAMP, tuple, collection of literals, array, number, literal, NULL, Bool, true, false, string literal, asterisk, qualified asterisk, compound identifier, list of elements, identifier, COLUMNS matcher, COLUMNS, qualified COLUMNS matcher, substitution, MySQL-style global variable. (SYNTAX_ERROR) (version 23.4.2.11 (official build))

or

Error - 09:22:21] Request admin/getdatabaseinfo failed.
  Message: Unhandled exception while handling request method admin/getdatabaseinfo: "'bool' object is not subscriptable"
  Code: -32603 

For postgreSQL can't connect with empty password

fe_sendauth: no password supplied

so, best options will implement ClickHouse support https://github.com/ClickHouse/clickhouse-connect/ via http

alexeik commented 11 months ago

Raise up No clickhouse support today