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 the ability to connect through a proxy server

    Add the ability to connect through a proxy server

    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 →
    • Refactoring does NOT take care of procudures and views

      This is a big problem for me.
      I renamed one table using the refactoring function.
      But all views and procedures which used this table were not automatically changed as I expected.
      Now I can't even open the views or procedures to manually edit them. All I get is: "unable to parse source text" which derives (so I think) from the now no more existing tables.
      I was able to edit the views with the help of phpMyAdmin. But I can't edit the procedure.
      This is a big issue for me.

      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  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

        Could you please describe the steps to reproduce the issue in details?

        Please also provide us the CREATE definitions of the objects.

        Additionally, please specify the version of dbForge.

      • set aliases for tables once and use in all sql scripts from then on

        I would love to be able to right click on a table and set an alias for that table that would then be used in the alias for scripts from then on rather than having to edit them each time
        for eg

        my_stupid_client_table

        i could set an alias of stupidClient to it

        so when I typed

        select from my_stupid_client_table

        autocomplete would use the alias for the table i previously specified to give

        select from my_stupid_client_table stupidClient

        ideally we could autocomplete on the specified aliases with a seperate hotkey, tab vs ctrl->space perhaps where one autocompleted as it does now and…

        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 →
        • Parent tabs for separate database instance

          Hello, I love your software and I am using it, so for many years using and my developing experiences, how about if I handle on multiple database per project and I opened very much database's table, so I recommend software have a parent's tab for each database inside it's child tab. Its very efficient to work and easier to sort them, I will continue using your software is my core tools, so I hope this feature will be integrated soon.

          Regard!

          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 →
          • Data Import

            import from odbc source: ability to import a whole odbc database at once , with the option to create new mysql database

            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 →
            • Better error description when concurrency exception occurs

              I opened a table and focused some data row. Then I created a new sql and did a few queries, one of them deleted a row in the table I've previously opened. But I didn't notice it. Then I returned to the opened table and edited the focused row (the one that was already deleted actually) and I got very generic error message, something like "An error has occurred during update operation". I spent a minute to understand that this is a concurrency exception because I've deleted a row I wanted to edit.

              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…)
                3 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
              • DB Health Analyzer

                Implement MySQL server health monitoring tool that can visualize server workload, memory consumption, IO operations, etc.

                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  ·  Flag idea as inappropriate…  ·  Admin →
                • Triple click anywhere on the line in the SQL editor should select the line.

                  To select a line you have to go to the gutter and click or do key strokes. Most editors allow a Triple-Click that expands to the entire line.

                  Double Click Selects the Word, Triple click selects the line

                  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  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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  ·  Flag idea as inappropriate…  ·  Admin →
                    • Quick jump to corresponding BEGIN <-> END

                      In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.

                      3 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 amount of records for compared Source and Target tables

                        On the Mapping page of the New Data Comparison wizard, show the number of the records containing in Source and Target tables.

                        Sometimes it appears to be the only criteria to exclude quite large tables from synchronization.

                        3 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 →
                        • Option "Ignore errors" while synchronizing process.

                          Now the synchronization aborts when an error occurs. Adding an option which overrules this behaviour and the synchronization process for a table continues.

                          3 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 →

                            Could you please provide us a screenshot of the synchronization you are referring to?

                            You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom

                          • Column highlight in insert statement

                            Tables with many columns (+20) becomes complex when you need to make insert. You need to make sure that the value is pointing to the correct column.

                            It will be a great feature to have the highlighted column matched with the value in the insert statements.

                            Like this:

                            INSERT INTO dbo.MyTable
                            (
                            Id,
                            Name,
                            LastName,
                            Age)
                            values
                            (1,
                            'john',
                            'Henrik',
                            22)

                            When clicking on the value John the Name column should be marked/highlighted. This means that the John value will be added to the Name column. And vice versa.

                            3 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 →
                            • Ability to turn off automatic syntax check

                              Add a button in the menu to turn off automatic syntax check and a button allowing to perform a one-time syntax check.

                              3 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 →
                              • 3 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 →

                                  This can be workarounded by using the MySQL command “SOURCE”. For example, in the new SQL file, you can type the following:

                                  SOURCE .\sqlfile1.sql;
                                  SOURCE .\sqlfile2.sql;

                                  SOURCE .\sqlfileN.sql;

                                  Here, instead of the local path .\ you can specify it explicitly as follows:

                                  d:\folder\sqlfile.sql

                                • Local Query Log of metadata changes: tables, procedures, views, UDFs, etc.

                                  Add a setting by default, that once enabled - stores queries that affect metadata changes in a kind of transaction log locally on hard disk.

                                  Recenlty I've got a problem with hosting provider, who got DB dumps with only data in it, but it's lack of saving tables, procedures, views and UDFs. Its a fail.

                                  3 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 →
                                  • implement developer express new FIND PANEL feature ASAP

                                    I have found this feature in the quantum grid suit to be outstanding - and you guys know as well as I do - how easy it is to make it available. This is a no brain feature. For those reading this and potential voter, imagine being able to search any column in the data from one simple search box. then a filter list of your search is presented to you in one click. This is achievable now without any special code on the behalf of devart. Come on vote for this and you will adore it.

                                    3 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 →
                                    • Ability to turn off adding comments when generating script as UPDATE

                                      Ability to turn off generating data type and default value comments when performing the 'Generate Script As -> UPDATE' operation.

                                      3 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 →
                                      • Selectively disable connections

                                        Currently I have 10 production servers and a couple of dev/test servers added to my Database Explorer, it would be awesome if there was an option to manually DISABLE/ENABLE a server entry. That way I have extra protection agains accidentally running a script on the wrong db.

                                        3 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 →
                                        • Allow users to remove close buttons from tabs

                                          The close buttons take up space and can be clicked by accident. Closing via the middle mouse button is a very useful pattern adopted by many apps, like Firefox & NetBeans.

                                          3 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 →
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base