Github And DBeaver

 Hopefully, you are regularly using both DBeaver and GitHub. But did you know that you can link them together?

If you are running DBeaver Community, you will have to install some software that is built into the Pro versions. 


1. Install Git Extension (Community Edition)
  • Go to Help -> Install New Software.
  • In the "Work with" field, enter: https://dbeaver.io/update/git/latest/.
  • Check the box for DBeaver Git Support, click Next, and follow the prompts to finish and restart DBeaver.
















2. Configure GitHub Authentication
GitHub requires a Personal Access Token (PAT) rather than your standard account password for DBeaver's connection:
  • Generate Token: On GitHub, go to Settings -> Developer Settings -> Personal access tokens -> Tokens (classic).
  • Permissions: Select all repo scopes and read:org under admin:org.
  • Copy Token: Save the generated token securely; you will use it as your password in DBeaver.
3. Connect/Clone a Repository
To link your DBeaver projects to GitHub:
  • Clone Existing Repo: Go to File -> Git -> Clone Repository (or Create Project from Git in the Projects tab).
  • Enter URI: Paste the repository URL (HTTPS) from your GitHub repository page.
  • My GitHub is listed

    Credentials:
    • User: Your GitHub username (or simply git).
    • Password: Paste your GitHub Personal Access Token.
  • Finish: Select the branches to clone and define a local directory for storage.
4. Git Operations in DBeaver
Once connected, you can manage your files via the Projects tab:
  • Commit/Push: Right-click a project or file and select Team -> Commit. In the "Git Staging" tab, stage your changes, enter a message, and click Commit and Push.
  • Pull: Right-click the project and select Team -> Pull to fetch the latest updates from GitHub.
  • AI Integration: You can also connect DBeaver to GitHub Copilot for SQL auto-completion by authorizing it under Engine settings.

Comments

Post a Comment

Popular posts from this blog

Migrating From MySQL To PostgreSQL in Five Simple Steps

Image
There are many reasons you may want to migrate from MySQL to PostgreSQL, which we will skip over for brevity.  I see many questions about moving tables and data, and sadly, the answers range from sloppy to incredibly complicated.  Each database migration is unique, as issues range from heavily relying on a vendor's feature to extremely complex schemas that require attention to minute detail. Step 1 This may seem obvious, but the first step is access to the original 'source' database. You will need FULL admin access to the database.  If you do not have full access for security, administrative, or other reasons, you will most likely not receive all the desired data.  We will use DBeaver Enterprise to connect to the source database. We need to choose a MySQL database driver Configure the connection We will be porting the World database. In this example, we will port the MySQL World database. This dataset has been used for decades in MySQL documentation, training, and ex...
Read more

Village SQL - A MySQL Fork With Easy Extensions

 I was happy to see a new MySQL fork appear. Village SQL  bills itself as 'A drop-in replacement for MySQL with extensions for the agentic AI era'. Mainstream Oracle MySQL does have Plug-ins, but I have found them less easy to develop and use than other implementations, such as PostgreSQL extensions. So how does it work? Head over to  https://github.com/villagesql/villagesql-server and follow the directions to clone and build the code. You will see detailed instructions for Linux and Mac builds. I followed the directions, let the make run overnight (slow hampsters in my testbed Ubuntu laptop).   The instructions were complete and easy to follow. First Run $ ~/build/villagesql/bin/mysql -u root -h 127.0.0.1 Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 10 Server version: 8.4.6-villagesql0.0.1-dev Source distribution Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corp...
Read more

Do You Need An AI Assistant?

Image
 Artificial Intelligence has been over hyped the last several years. But one of the bright, shining spots for AI is acting as an assistant. a super-powerful IDE, when working with a database. Example You want to find your top three customers in the Sakila database. This database has been used for decades in the MySQL world. As your question in English (or another language) The '@ai' directs the rest of the prompt to the DBeaver Artificial Intelligence Assistant See the generated SQL Here is the generated Structured Query Language And get the results. Now we have the top three customers without having to write any SQL directly Fixing Mistakes Occasionally, you may 'fat finger' a query.  I will take the query from above and change first_name to just first .   SELECT c . customer_id , c . first , c . last_name , SUM ( p . amount ) AS total_revenue FROM customer AS c JOIN payment AS p ON c . customer_id = p . customer_id GROUP BY ...
Read more