> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-detect-table-modification.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> DBeaver é uma ferramenta de banco de dados multiplataforma.

# Conectar o DBeaver ao ClickHouse

export const PartnerBadge = () => {
  return <div className="PartnerBadge">
            <div className="PartnerBadgeIcon">
                <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                    <polyline points="12.5 9.5 10 12 6 11 2.5 8.5" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <polyline points="4.54 4.41 8 3.5 11.46 4.41" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M2.15,3.78 L0.55,6.95 A0.5,0.5 0,0,0 0.77,7.62 L2.5,8.5 L4.54,4.41 L2.82,3.55 A0.5,0.5 0,0,0 2.15,3.78 Z" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M13.5,8.5 L15.23,7.62 A0.5,0.5 0,0,0 15.45,6.95 L13.85,3.78 A0.5,0.5 0,0,0 13.18,3.55 L11.46,4.41 Z" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <path d="M11.5,4.5 L9,4.5 L6.15,7.27 A0.5,0.5 0,0,0 6.24,8.05 C7.33,8.74 8.81,8.72 10,7.5 L12.5,9.5 L13.5,8.5" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                    <polyline points="7.75 13.5 5.15 12.85 3.5 11.67" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" strokeWidth="1" />
                </svg>
            </div>
            Integração com parceiro
        </div>;
};

export const Image = ({img, alt, size = "lg"}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} />
      </Frame>
    </div>;
};

O DBeaver está disponível em várias versões. Neste guia, usamos o [DBeaver Community](https://dbeaver.io/). Veja as diferentes versões e recursos [aqui](https://dbeaver.com/edition/). O DBeaver se conecta ao ClickHouse usando JDBC.

<Note>
  Use o DBeaver versão 23.1.0 ou superior para ter melhor suporte a colunas `Nullable` no ClickHouse.
</Note>

<div id="1-gather-your-clickhouse-details">
  ## 1. Reúna as informações do seu ClickHouse
</div>

O DBeaver usa JDBC sobre HTTP(S) para se conectar ao ClickHouse; você precisa de:

* endpoint
* número da porta
* nome de usuário
* senha

<div id="2-download-dbeaver">
  ## 2. Baixe o DBeaver
</div>

O DBeaver está disponível em [https://dbeaver.io/download/](https://dbeaver.io/download/)

<div id="3-add-a-database">
  ## 3. Adicione um banco de dados
</div>

* Use o menu **Database > New Database Connection** ou o ícone **New Database Connection** no **Database Navigator** para abrir a caixa de diálogo **Connect to a database**:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-add-database.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=44103f5900f1bd90f591c126a90c12f3" size="md" border alt="Adicionar um novo banco de dados" width="642" height="385" data-path="images/integrations/sql-clients/dbeaver-add-database.webp" />

* Selecione **Analytical** e, em seguida, **ClickHouse**:

* Monte a URL JDBC. Na guia **Main**, defina Host, Port, Username, Password e Database:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-host-port.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=1ce5e7d89fca74d9a18146102dfb3438" size="md" border alt="Defina o hostname, a porta, o usuário, a senha e o nome do banco de dados" width="650" height="654" data-path="images/integrations/sql-clients/dbeaver-host-port.webp" />

* Por padrão, a propriedade **SSL > Use SSL** não estará ativada. Se você estiver se conectando ao ClickHouse Cloud ou a um servidor que exige SSL na porta HTTP, ative **SSL > Use SSL**:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-use-ssl.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=1d381b53bc8ba7b32260ee76a958ca8f" size="md" border alt="Ative SSL, se necessário" width="650" height="654" data-path="images/integrations/sql-clients/dbeaver-use-ssl.webp" />

* Teste a conexão:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-test-connection.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=761b61f40e417370d00c92a55cab106a" size="md" border alt="Teste a conexão" width="650" height="654" data-path="images/integrations/sql-clients/dbeaver-test-connection.webp" />

Se o DBeaver detectar que você não tem o driver do ClickHouse instalado, ele oferecerá baixá-lo para você:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-download-driver.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=61c84fdce9a426fb60def6de4554f1cb" size="md" border alt="Baixe o driver do ClickHouse" width="612" height="689" data-path="images/integrations/sql-clients/dbeaver-download-driver.webp" />

* Após baixar o driver, **Test** a conexão novamente:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-test-connection.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=761b61f40e417370d00c92a55cab106a" size="md" border alt="Teste a conexão" width="650" height="654" data-path="images/integrations/sql-clients/dbeaver-test-connection.webp" />

<div id="4-query-clickhouse">
  ## 4. Consultar o ClickHouse
</div>

Abra um editor de consultas e execute uma consulta.

* Clique com o botão direito na conexão e escolha **SQL Editor > Open SQL Script** para abrir um editor de consultas:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-sql-editor.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=4c870736a7ab7064a4b987bf2fa945ca" size="md" border alt="Abrir o editor SQL" width="636" height="162" data-path="images/integrations/sql-clients/dbeaver-sql-editor.webp" />

* Exemplo de consulta em `system.query_log`:

<Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/sWsbrb2bBAr-0f9w/images/integrations/sql-clients/dbeaver-query-log-select.webp?fit=max&auto=format&n=sWsbrb2bBAr-0f9w&q=85&s=b3fc18c1700dcd9dbd06a1cca5c1eb8b" size="md" border alt="Uma consulta de exemplo" width="712" height="316" data-path="images/integrations/sql-clients/dbeaver-query-log-select.webp" />

<div id="next-steps">
  ## Próximas etapas
</div>

Consulte a [wiki do DBeaver](https://github.com/dbeaver/dbeaver/wiki) para saber mais sobre os recursos do DBeaver e a [documentação do ClickHouse](/pt-BR/) para saber mais sobre os recursos do ClickHouse.