Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on an open-source framework and allows the writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases and different database management utilities (e.g. ERD).
1047 questions
155
votes
4 answers

DBeaver can only see default PostgreSQL database in connection

I use DBeaver v 5.2.5 on Windows and use it to connect to PostgreSQL databases. To create a connection, I must specify the database and I have no mean to see other databases on the same server. A colleague using DBeaver 5.3 on Mac has an option to…
Eric Mamet
  • 2,681
  • 2
  • 13
  • 43
139
votes
9 answers

How to switch the capitals characters transform in DBeaver?

The SQL editor in DBeaver has this unsupportable feature of transforming all capital characters into lower case. This happens as you type, the most schizophrenic thing. I have searched in the menus and the Preferences dialogue, but I can not find…
Luís de Sousa
  • 5,765
  • 11
  • 49
  • 86
138
votes
9 answers

Recover DB password stored in my DBeaver connection

I forgot the password of a dev instance (irresponsible.. yeah, I am working on it). I have the connection saved in my DBeaver with the password. I am still able to connect using that connection. DBeaver is not showing it in plain text. Is there…
Git_gal
  • 1,399
  • 2
  • 9
  • 5
121
votes
13 answers

How can I export DBeaver connection configurations?

I was hoping there is a way to export DBeaver connection configurations/properties from my old machine rather than having to go through the process of recreating each one. Does anyone know how to do this? The DBeaver version on my old machine is…
jaydel
  • 14,389
  • 14
  • 62
  • 98
121
votes
4 answers

Export result set on Dbeaver to CSV

Normally I use Dbeaver for windows and always export my result set like this: Run my query --> select the result --> export the result set --> select export to clipboard --> done This step by step puts my result set in my clipboard and I can paste…
Rafael Meirelles
  • 1,323
  • 2
  • 8
  • 10
71
votes
7 answers

Ubuntu Dbeaver backup database

I have Dbeaver installed and I have a connection to a PostgreSQL database on a remote server. I'd like to export this database to my local PC but when I go to Tools -> Backup database I see an error Client home is not specified for connection What…
GriMel
  • 2,272
  • 5
  • 22
  • 40
68
votes
4 answers

DBeaver, export from database Postgres, table structure (properties) into file .txt

I have little problem with DBeaver. I want to export my structure from each table from database in file .txt. I found how to export all data but I don't need this data, just table structure. If you have some solutions for export table structure .csv…
Iani M.D.
  • 783
  • 1
  • 6
  • 7
55
votes
5 answers

The line number on the SQL Editor in DBeaver

How to toggle the line number on the SQL Editor in DBeaver? I can't find this option in Window / Preferences / General / Editors / SQL Editor. Is it possible to do this?
simhumileco
  • 31,877
  • 16
  • 137
  • 115
50
votes
9 answers

How to change DBeaver timezone / How to stop DBeaver from converting date and time

When I use DBeaver with Cassandra, it shows an offset of +01:00 even though the data is stored in Date or Times formats, that don't have any timezones. This results in some weird queries like this: SELECT "Time" FROM keyspace."Table" ORDER BY…
Edu
  • 2,354
  • 5
  • 32
  • 36
49
votes
5 answers

How to execute a SQL script in DBeaver?

I have a number of .sql files that I wish to execute through DBeaver. Traditional database development programmes allow the user to edit and run SQL scripts (totally or partially) in the same window, but this is not obvious with DBeaver. When I open…
Luís de Sousa
  • 5,765
  • 11
  • 49
  • 86
45
votes
5 answers

DBeaver, How to declare variables and use them?

i just want to know if it is possible to declare variables on the DBeaver´s sql editor and use them on a query
Elliott Urrutia
  • 589
  • 1
  • 5
  • 11
45
votes
3 answers

DBeaver Can't access non-default database

I'm using DBeaver 3.8.0 and trying to setup general connection to my local PostgreSQL database. To view all the databases i have, I check the "Show non-default databases" checkbox. And when I try to access Schemas of one of my databases - I'm…
Jekis
  • 4,274
  • 2
  • 36
  • 42
36
votes
4 answers

Connection between DBeaver & MySQL

I use DBeaver to watch an SQL database on MySQL 8+. Everything is working, but sometimes, opening DBeaver, I have the following error message : Public Key Retrieval is not allowed And then, DBeaver can't connect to MySQL. In order to fix this…
Alex Dana
  • 1,076
  • 3
  • 14
  • 30
36
votes
1 answer

How do I run arbitrary SQL on DBeaver?

Ok, so this may seem like a stupid question but I'm fighting DBeaver and so far it's winning and Google is refusing to pick a side. I've worked out how to explore the database, view the structure of tables, I can even view the data of a table and…
Tim B
  • 40,716
  • 16
  • 83
  • 128
32
votes
3 answers

DBeaver file encoding (cp1250 - Windows-1250) - change default encoding?

I have a problem setting encoding in DBeaver, specifically SQL file encoding (not db encoding!) to cp1250 (Windows-1250) No problem to set such encoding for new files/scripts - right click on Scripts folder (or the whole project folder, from which…
Tom
  • 423
  • 1
  • 4
  • 13
1
2 3
…
69 70