[FEATURE] 增加 Vertica 数据库支持 (基于 vertica-python)

Open
#1,002 1 comment 0 reactions 2 assignees View on GitHub

@yayanpei-fit2cloud is already working on this.

Since Mar 23, 2026.

Assessment

This issue has not been assessed yet.

Description

feature

SQLBot 1.7.0

需求背景

希望能原生支持 Vertica 数据库，以便直接连接和分析存储在 Vertica 数据仓库中的大规模数据，避免繁琐的中间导出步骤

实现建议
  • 驱动程序：建议使用官方维护的 vertica-python（完全兼容 Python DB API 2.0）。
  • SQLAlchemy 支持：如果项目基于 SQLAlchemy，可直接复用现有的 sqlalchemy-vertica 方言。
  • 关键配置：默认端口 5433，支持标准连接参数（host, user, database, password）。
测试方案 (CI/CD 友好)

无需商业许可证，维护者可使用免费的 Vertica Community Edition (CE) Docker 镜像轻松搭建测试环境
docker pull vertica/vertica-ce:24.1.0-0

参考链接

驱动文档：https://pypi.org/project/vertica-python/
vertica镜像参考：https://blog.csdn.net/weixin_42316373/article/details/144888221

Dominant language
JavaScript
Stars
6.8k
Forks
882
Avg merge
4h 41m
Merged PRs (30d)
35

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from dataease/SQLBot

All issues in dataease/SQLBot

Similar issues

More JavaScript issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.