dbForge Studio for MySQL

dbForge Studio for MySQL is a universal set of MySQL GUI tools for database management, administration and development. It enables to create and execute queries, develop and debug MySQL routines, and automate MySQL database object management in the convenient environment.

http://www.devart.com/dbforge/mysql/studio/

I suggest you...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Add switch key to mouse click to open table in different views

    Add a switch key (SHIFT, CTRL or ALT) to the mouse click behavior to open a table in design, text or data view with a single click.

    6 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
    • Add JDBC connection support

      Add ability to use JDBC connections (like dbVisualizer) for access to other DB's (I personally need it for as400 / iSeries / System i data). Initial release could just support data viewing, import.

      6 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
      • Pop up procedure and function params on Ctrl+Space like variables

        Now, when we edit function or procedure, we can insert first letters of any var, then press Ctrl+Space and see list with types, tables and procedure (or function) variables. So, please add function params (or procedure... :)

        6 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
        • 5 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Disable foreign keys when deleting or truncating table

            When deleting or truncating a table I would like to have the option to disable foreign key checks for this operation. This could be a simple check box which is unchecked by default.
            If foreign keys are present, I either have to drop the database and recreate the whole schema or delete one-by-one figuring out the correct order or I have to write an SQL script with a lot of drop table statements and surrounding them with the foreign key checks setting.
            This is cumbersome, especially for development purposes when I have to clear test data very often or deploy…

            5 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
            • Table does not get renamed from initial caps to lowercase

              If you rename a table and change it from initial caps to lowercase, it doesn't get renamed. For example, you can't rename it from "Calls" to "calls".

              5 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
              • Ability to import nested xml tags

                Your XML import only can deal with a single dimension of data. There is no way of dealing with the [Link] second hierarchy. Properly creating a schema and/or entities is very important now with web services and there are not many programs that can do it.

                5 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • execute selection

                  Execute selection should execute all sql code if nothing is selected (the same as it is in Microsoft management studio).

                  So if we click on a shortcat for "Sql -> Execute selection" and have no code selected dbForge should do "Sql -> Execute"

                  5 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                  • Show refactoring changes in open tabs.

                    There are numerous cases where renaming an object, like a table, or field does not update the source of an open stored procedure.

                    Also, the auto-complete options in the editor are not updated when a new table or field is added, even if its added through the same connection and DBForge instance. Often I am presented with auto-complete suggestions that are completely invalid.

                    5 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                      Please note that you can use the ‘Automatically refresh suggestions cache every xxx minutes’ option available in the ‘General’ branch of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu.

                    • Clustrix (ClustrixDB)

                      Hi there, Clustrix uses mySQL protocol, so many third party db mangers work. There are some subtle differences, but nothing that others like Heidi, DbVisualiser or dbSchema couldn't handle. I'd like to try dbForge on my Clustrix project but connection says 'unknown variable: max_sort_length'.

                      5 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                      • Comma separated values when copying cell data

                        When you copy cell data, for example 5 ids, I would like to be able to copy them as comma separated data in order to use in IN statements.

                        For example, if you have 3 rows of results like the following:
                        id name
                        1 George
                        2 John
                        3 Gregory

                        I wish to copy ids as comma separated values in order to use them in a Select statement like:
                        SELECT * FROM temp t where t.id in (1, 2,3)

                        5 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                        • Include row count in SQL profile results page. Saves switching to data view to see # records retrieved.

                          Include row count in SQL profile results page. Saves switching to data view to see # records retrieved.

                          5 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Implement the ability to copy entire database to another server

                            In SQLyog, there's a simple "copy entire database to another server", which allows to copy objects to another server in just a click.

                            5 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                            • data comparisons, add abilty to view by row stacking

                              While viewing records in data comparisons, add abilty to view in column side-by-side (as currently available) -OR- by row stacking

                              5 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                              • Execution of a single query to multiple databases

                                Execution of a single query to multiple databases

                                5 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                • SQL History: log in plain mode without parameter

                                  I know that in SQL LOG dbforge could store ALL query sent to DB. It would be great if dbforge stored them in plain form with parameter already substituted (not with :p1, :p2 .. and so on)

                                  5 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                  • drag and drop column names into query

                                    Multi-select column Names (works).
                                    Drag and drop as a COMMA List in the SQL Editor (does not work)

                                    Even better, if the SQL Text area is empty or being dropped after a ; with no open SQL statement, include "Select " + $fields + " from " + $table with it!

                                    4 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Generate cleaner SQL

                                      It would be really nice if dbForgeStudio generated cleaner SQL code. Currently, the code generated by dbForge is very confusing and differs too much from the code generated by hand. There is no option to turn some settings off.

                                      This is a problem if we need to maintain SQL scripts that are manually edited later. Everytime we need to export a script, we need to manually format the code and remove all the unecessary stuff.

                                      Some of the issues are:

                                      1) Every identifier is escaped even if it is plain english text. View generation gets really confusing by escaping every…

                                      4 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Conditional breakpoint

                                        Hi, there is a suggestion for improvements :
                                        It could be usefull to have possibility for conditional breakpoint in Stored Procedure debuging. For example, in a procedure, i put a breakpoint, but i want the process to stop only if some variable has a specific value.
                                        And by the way, it could be also usefull to see the value of a use variable. For exemple, if a define a variable v_var, when the mouse cursor is over the variable, i can see an info about this variable, but if i define another like @v_var (with the @ prefix), this doesn't…

                                        4 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Set toolbar fixed

                                          fix the toolbar so that it can not be accidentally moved during normal working.

                                          The fixation can be disabled/enabled in the toolbar configuration.

                                          4 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base