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?

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
2
  • I don't know python proficiently, so can you recommend alternatives?
    – Prashanna Guru
    Commented Sep 27, 2019 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
    Commented Sep 27, 2019 at 22:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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