blocks|key|337565|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|337566|337567|开源|unordered-list-item|337568|可与许多数据库一起使用|337569|337570|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|J|7|@]|8|@]|9|$]]|$1|A|3|-4|4|5|6|K|7|@]|8|@]|9|$]]|$1|B|3|C|4|D|6|L|7|@]|8|@]|9|$]]|$1|E|3|F|4|D|6|M|7|@]|8|@]|9|$]]|$1|G|3|-4|4|5|6|N|7|@]|8|@]|9|$]]|$1|H|3|-4|4|5|6|O|7|@]|8|@]|9|$]]]|I|$]]

<a href="http://squirrel-sql.sourceforge.net/" rel="noreferrer">SQuirreL SQL</a>

<ul>
<li>Open source</li>
<li>Works with many databases</li>
</ul>

blocks|key|340109|text|SqlDbx+-+www.sqldbx.com+-有一个免费的版本，是便携式的，可以与相当多的数据库一起工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|340110|也叫AnySQL+Maestro+-+http://www.sqlmaestro.com/products/anysql/maestro/|offset|length|340111|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlmaestro.com/products/anysql/maestro/^0|0|J|1E|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

SqlDbx - www.sqldbx.com - has a free edition, is portable and works with quite a few dbs.

Also AnySQL Maestro - <a href="http://www.sqlmaestro.com/products/anysql/maestro/" rel="noreferrer">http://www.sqlmaestro.com/products/anysql/maestro/</a>

blocks|key|3103057|text|只要我必须在Oracle数据库上工作，我就会使用。我喜欢它的用户界面，简单而快速。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3103058|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I use <a href="http://www.allroundautomations.com/plsqldev.html" rel="nofollow noreferrer">PL/SQL Developer</a>, as soon as I have to work on an Oracle Database. I like the UI, simple and fast.

blocks|key|335190|text|我使用Aqua+Data+Studio已经有很多年了，它是我所有工具中最有价值的--参见Aquafold|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|335191|entityMap|0|LINK|mutability|MUTABLE|url|http://www.aquafold.com/^0|18|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I'm using Aqua Data Studio for many years now and it is the most valuable of all my tools - see <a href="http://www.aquafold.com/" rel="nofollow noreferrer">Aquafold</a>

blocks|key|337550|text|DbVisualizer+-有一个功能有限的免费版本和一个完全成熟的版本，售价149美元。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|337551|entityMap|0|LINK|mutability|MUTABLE|url|https://www.dbvis.com/^0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="https://www.dbvis.com/" rel="nofollow noreferrer">DbVisualizer</a> - there's a free version with a bit limited functionality and a fully fledged one for $149.

blocks|key|3315848|text|我自己也用Navicat。它支持MySQL、PostgreSQL和Oracle。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3315849|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I use Navicat myself. It supports MySQL, PostgreSQL and Oracle.

blocks|key|3315966|text|SQL+Developer很适合Oracle，并且有其他几个数据库的插件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3315967|3315968|+http://www.oracle.com/technology/products/database/sql_developer/index.html|blockquote|offset|length|3315969|3315970|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/products/database/sql_developer/index.html^0|0|0|1|23|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|S|8|@]|9|@$F|T|G|U|1|V]]|A|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

SQL Developer is nice for Oracle and has plugins for several other databases.

<blockquote>
 <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow noreferrer">http://www.oracle.com/technology/products/database/sql_developer/index.html</a>
</blockquote>

blocks|key|3103188|text|Eclipse+(我的主要集成开发环境)中的Eclipse+Data+Tools+Platform：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3103189|3103190|开源，适用于许多数据库|unordered-list-item|3103191|做所有的基础和一些高级的东西。在最近的版本中，您还可以找到某种类型的visual+query+builder。|3103192|Oracle有一个plugin，其中实现了一些Oracle特定的函数。|3103193|3103194|entityMap|0|LINK|mutability|MUTABLE|url|http://www.iipt.fr/dtptutor.html|1|http://files.zend.com/help/Zend-Studio-Eclipse/creating_and_executing_an_sql_query.htm|2|http://download.oracle.com/docs/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html^0|M|R|0|0|0|0|Y|K|1|0|9|6|2|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|-4|5|6|7|12|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|13|8|@]|9|@]|C|$]]|$1|H|3|I|5|G|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|J|3|K|5|G|7|18|8|@]|9|@$A|19|B|1A|1|1B]]|C|$]]|$1|L|3|-4|5|6|7|1C|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]|W|$5|P|Q|R|C|$S|X]]]]

<a href="http://www.iipt.fr/dtptutor.html" rel="nofollow noreferrer">Eclipse Data Tools Platform</a> within Eclipse (my primary IDE):

<ul>
<li>Open source, works with many databases</li>
<li>Do all the basics and some advanced stuff. In recent versions you can find some kind of <a href="http://files.zend.com/help/Zend-Studio-Eclipse/creating_and_executing_an_sql_query.htm" rel="nofollow noreferrer">visual query builder</a> as well. </li>
<li>Oracle has a <a href="http://download.oracle.com/docs/cd/E14545_01/help/oracle.eclipse.tools.database.doc/html/gettingStarted/files/gettingStarted.html" rel="nofollow noreferrer">plugin</a> where implemented some Oracle-specific functions.</li>
</ul>

blocks|key|335262|text|如果你正在使用PostgreSQL+(真的，你应该这样做！)，PgAdmin很棒。它允许您查询、浏览表格、执行管理任务、管理用户、直观地解释复杂查询、以图形方式构建查询等等。它可以在Windows、Linux和OS上运行，可以连接到本地或远程PostgreSQL服务器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|335263|entityMap|0|LINK|mutability|MUTABLE|url|http://www.pgadmin.org/^0|V|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you are using PostgreSQL (and, really, you should be!), <a href="http://www.pgadmin.org/" rel="nofollow noreferrer">PgAdmin</a> rocks. It lets you query, explore tables, do administrative tasks, manage users, visually explain complex queries, graphically build queries and much more. It runs on Windows, Linux and OS X and can connect to local or remote PostgreSQL servers.

blocks|key|3103103|text|MySQL的SQLyog。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3103104|我在甲骨文工作时的TOAD。|3103105|​|3103106|📷|atomic|3103107|3103108|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webyog.com/en/|1|http://www.toadsoft.com/toad_oracle.htm|2|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1e118c9a4fe96bb3f1689be7a9ccc31c.png|imageAlt^0|6|6|0|0|9|4|1|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@$A|16|B|17|1|18]]|C|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|1A|8|@]|9|@$A|1B|B|1C|1|1D]]|C|$]]|$1|K|3|G|5|6|7|1E|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]|T|$5|O|P|Q|C|$R|U]]|V|$5|W|P|X|C|$Y|Z|10|-4]]]]

<a href="http://www.webyog.com/en/" rel="nofollow noreferrer">SQLyog</a> for MySQL.

<a href="http://www.toadsoft.com/toad_oracle.htm" rel="nofollow noreferrer">TOAD</a> for when I worked with Oracle.

<img src="https://i.stack.imgur.com/JLYCX.png" alt="enter image description here">

blocks|key|335210|text|我更喜欢...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|335211|335212|PL/SQL+Developer+for+Oracle|unordered-list-item|offset|length|335213|MSSQL|335214|的内置工具DB2|335215|的内置工具|335216|entityMap|0|LINK|mutability|MUTABLE|url|http://www.allroundautomations.com/plsqldev.html^0|0|0|0|G|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|X|8|@]|9|@$F|Y|G|Z|1|10]]|A|$]]|$1|H|3|I|5|E|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

I prefer...

<ul>
<li><a href="http://www.allroundautomations.com/plsqldev.html" rel="nofollow noreferrer">PL/SQL Developer</a> for Oracle</li>
<li>The inbuilt tool for MSSQL</li>
<li>The inbuilt tool for DB2</li>
</ul>

blocks|key|3316093|text|RazorSQL+-它适用于几乎任何你能想到的数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3316094|entityMap|0|LINK|mutability|MUTABLE|url|http://www.razorsql.com/^0|0|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.razorsql.com/" rel="nofollow noreferrer">RazorSQL</a> - it works with pretty much any database you can think of.

blocks|key|3316108|text|对LyteRAD有什么评论吗？不是一个纯粹的数据库管理工具，但很适合快速创建和原型数据库应用程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3316109|entityMap|0|LINK|mutability|MUTABLE|url|http://www.lytecube.com/lyterad^0|1|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Any comments on <a href="http://www.lytecube.com/lyterad" rel="nofollow noreferrer">LyteRAD</a>? Not a pure database management tool, but good for creating and prototyping db apps quickly.

blocks|key|336700|text|我用过Query+Express，它很棒，因为它实际上是一个独立的100KB文件，不需要安装。它只做查询，但它是快速和免费的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|336701|entityMap|0|LINK|mutability|MUTABLE|url|http://www.albahari.com/queryexpress.aspx^0|3|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I've used <a href="http://www.albahari.com/queryexpress.aspx" rel="nofollow noreferrer">Query Express</a> and it's great because it's actually a standalone 100 KB file, no installation needed. It only does querying but it's fast and free.

blocks|key|3316171|text|如果您需要数据比较、模式比较或可视化查询构建器，那么您应该看看我们的database+tools+for+SQL+Server|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3316172|3316173|dbForge+Schema+Compare+for+SQL+Server|unordered-list-item|3316174|dbForge+Data+Compare+for+SQL+Server|3316175|dbForge+Query+Builder+for+SQL+Server|3316176|3316177|所有这些工具都非常实惠，并且有30天的试用期。|3316178|entityMap|0|LINK|mutability|MUTABLE|url|http://www.devart.com/dbforge/sql/|1|http://www.devart.com/dbforge/sql/schemacompare/|2|http://www.devart.com/dbforge/sql/datacompare/|3|http://www.devart.com/dbforge/sql/querybuilder/^0|Y|T|0|0|0|0|11|1|0|0|Z|2|0|0|10|3|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|-4|5|6|7|16|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|H|3|I|5|G|7|1B|8|@]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|J|3|K|5|G|7|1F|8|@]|9|@$A|1G|B|1H|1|1I]]|C|$]]|$1|L|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1K|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|1L|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]|W|$5|R|S|T|C|$U|X]]|Y|$5|R|S|T|C|$U|Z]]|10|$5|R|S|T|C|$U|11]]]]

If you need data comparison, schema comparison or visual query builder, than you should take a look at our <a href="http://www.devart.com/dbforge/sql/" rel="nofollow">database tools for SQL Server</a>:

<ul>
<li><a href="http://www.devart.com/dbforge/sql/schemacompare/" rel="nofollow">dbForge Schema Compare for SQL Server</a></li>
<li><a href="http://www.devart.com/dbforge/sql/datacompare/" rel="nofollow">dbForge Data Compare for SQL Server</a></li>
<li><a href="http://www.devart.com/dbforge/sql/querybuilder/" rel="nofollow">dbForge Query Builder for SQL Server</a></li>
</ul>

All these tools are quite affordable and have 30-days trial period.

Wondering what is the best or most popular database client tool. Similar to Microsoft's SQL management studio, but one that can work with various databases. Other tools I have found are:

<ul>
<li><a href="http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm" rel="noreferrer">Toad for SQL Server</a></li>
<li><a href="http://daft.sourceforge.net/" rel="noreferrer">Database fishing tool</a></li>
<li><a href="http://www.apexsql.com/sql_tools_univ_studio.asp" rel="noreferrer">Apex SQL Studio</a></li>
</ul>

Some of these tools can even compare and sync database schema's and some cases the data itself as well. Very useful when deploying applications for example from a pre-production environment to production environment.

So what's your favourite database manager ? Maybe there is a nice open source tool out there that is well rounded with the most useful features.

Your favourite database client tool

集成开发环境

数据库管理

Oracle数据库

PostgreSQL

数据库

服务器

Windows

Eclipse

MySQL

Linux

想知道什么是最好或最流行的数据库客户端工具。类似于微软的SQL管理工作室，但它可以与各种数据库一起工作。我找到的其他工具有：其中一些工具甚至可以比较和同步数据库模式以及某些情况下的数据本身。在部署应用程序时非常有用，例如，从预生产环境部署到生产环境。那么你最喜欢的数据库管理器是什么呢？也许有一个很好的开源工具，它包含了最有用的功能。

问您最喜欢的数据库客户端工具
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问您最喜欢的数据库客户端工具EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问您最喜欢的数据库客户端工具
EN