0

I am currently using a SQL Client called Dbeaver to query data from Postgresql and MySQL database individually. But recently there is a use case, where there is a need to combine data from this two database and then write a query.

Dbeaver doesn't have this capability. So I want to know if this is a limitation in all SQL Client or just DBeaver. If the issue is with DBeaver, then which SQL Client will allow me to combine data from two different database and then write a query?

0

If you're open to using a scripting client instead of a GUI client, then you might look into execsql.py. It allows you to connect to multiple databases (one on startup, others with the CONNECT metacommand). You can then copy a table or view from one database to another with the COPY metacommand and write queries to combine the data as needed.

Disclaimer: I wrote execsql.

  • I don't know python proficiently, so can you recommend alternatives? – Prashanna Guru Sep 27 at 22:45
  • No, I don't know of another tool with those capabilities, which is part of the reason why I wrote my own. But you don't need to know Python to use it, you just need to have Python installed so that execsql.py will run. – rd_nielsen Sep 27 at 22:47
  • thanks will give it a try – Prashanna Guru Sep 27 at 23:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.