[Database Support] MySQL

[sbehara1]

If you want to see MySQL support in Azure Data Studio, click the thumbs up sign.

Note: Please keep comments to this issue focused on discussions of what you would like to see instead of +1 comments.

[ghost]

Seems support mysql 5.6+ is enough for us.

[ghost]

Would like to see mysql over ssh , mysql tcp/ip, mysql unix socket , these three way connect mysql

[dsghi]

Product name is Azure Data Studio, not MSSQL Data Studio, so I would expect the ability to connect to and manage any database product that is supported on Azure, including MySQL. :)

[m34nbunny]

I am wishing for this everyday, is there a feature branch that has been started for this support yet?

Would love to help contribute

[ghost]

With Azure database for MySQL I would imagine Azure Data Studio should be able to support T-SQL on MySQL. I am starting to look into moving from Google Cloud Platform to Microsoft Azure for WordPress hosting. Using Azure Data Studio and snippets would fit in nicely.

[bonolo]

I would love this functionality. Bog standard 8.0 would be ideal. Even full support of 5.x would make me happy.

[zollo]

I'd appreciate support for MySQL/MariaDB - supported versions only.

[GaboFDC]

Would be nice to get an update on the status of this, just to know if still being considered, if is approved and will be done at some point in the future, just to know what to expect, for know it seems like the support will not come any time soon :(

[vijaychandar1989]

Please give us an update about the support from mysql. I badly require this support.

[499978920]

mysql support we need please.

[Leonardo-Ferreira]

Just here to reaffirm that basic query execution agains a MYSQL database would suffice... no auto completion needed or other fancy features...

[jemiller0]

Microsoft's video at https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15 at 6:48 states that Azure Data Studio supports MySQL. However, while I was able to enable PostgreSQL support using the extension, I don't see an extension for MySQL. Am I missing something?

[firanto]

Since this is a multi platform SQL client, it should at least support MySQL. MySQL 5 is fine. 8 is a plus. The reason is simple. MySQL (and its derivative, MariaDB) still known as a popular choice of relational database. Specially for those who work with unix-like servers. The fact that this tool ran at linux and can't even connect to MySQL, even after mentioned since April last year, is baffling.

[Wauna]

Joining the fray... any update on this?

[btstream]

Any plan or roadmap?

[frugecn]

There's been a couple of demos from Microsoft where I've seen the extension, sure would be nice to see it released.

[maiksandmann]

Any update about the availability of a MySQL connector in Azure Data Studio?

Thx for any feedback. maik

[naimsulejmani]

There the missing piece of Azure Data Studio is MySQL Connector also some good IntelliSense for that :)

[rafaribe]

Would be superb to have MySQL support. The only other alternative in MacOS is DataGrip and is slow as hell..

[datauduong]

With Notebook support in Azure Data Studio, it would be very useful to be able to connect to Azure MySQL (Knowing Azure PostgreSQL already been supported in Azure Data Studio)

Azure Data Studio team can you please shed some light on whether this is considered so that we can see the end.

Thanks.

[myusrn]

Its more than a year since this issue was opened. Is support for localhost or azure hosted mysql connection still not supported?

Searched extensions and not seeing any hits.

[rafaribe]

Would appreciate if the devs could just shed some light if they care about such support or not. Just look at the emoji count of the first post. The community cares.

[ramonpego]

i'll have faith

[asharovarov]

Are there any updates on the progress?

[firanto]

No response from devs for don't know how long... 😶

[stefanreimers]

We asked about that on Twitter but until now we only got a vague answer from the PM https://twitter.com/OneBitAhead/status/1307954947036717056

[myusrn]

Fyi, as an interim alternative i'm using azure data studio supported jupyter notebook with python kernel and the standard issue mysql pypi package. An overview can be found in this 10min walkthrough video and summarized in the following.

1. install azure data studio
2. azure data studio | file | new notebook
3. <notebook>.ipynb | manage packages | add new | mysql and mysql-connector
4. set db_host=<your_db_host>& set db_user=<your_db_user>& set db_pswd=<your_db_pswd>& set db_name=<your_db_name> . . . and for linux distro leave out set or swap with export for enabling across all processes
5. use following code in notebook code cell or spread across many cells if you want to intermix with markdown information

import mysql.connector as mysql; 
db_host = os.environ.get('db_host'); db_user = os.environ.get('db_user'); db_pswd = os.environ.get('db_pswd'); db_name = os.environ.get('db_name')
db_conn = mysql.connect(host=db_host, user=db_user, passwd=db_pswd, database=db_name, use_pure = True)
db_conn # or print(db_conn)

db_tables = pd.read_sql_query('show tables from ' + db_name, db_conn)
db_tables # or print(db_tables)

tables = db_tables['Tables_in_' + db_name]
tables # or print(tables)
for table_name in tables: 
    output = pd.read_sql_query('describe {}'.format(table_name), db_conn)
    print('describe ' + table_name)
    print(output, '\n')

Should be clear that the python pandas package call pd.read_sql_query('<mysql statements>', db_conn) is how you execute mysql commands and view output in notebook. For some use cases this azure data studio notebook approach may be preferred given you get the benefits of being able to insert nice markdown in between statements and have output for a given run captured in a nicely formatted way for sharing.

[noahbroyles]

Yeah Microsoft what the heck mon? Where is support for the most common free RDBMS?

[tinwinaung]

I believe most want to use MariaDB ... please thumb up on MariaDB request here https://github.com/Microsoft/azuredatastudio/issues/4917

[nmklotas]

There's no good mysql/mariadb IDE, so support for mysql/mariadb in Azure Data Studio would be much appreciated!

[jemiller0]

They are probably doing it for business/political reasons. Just like Oracle refuses to make a provider for Entity Framework Core. They should add support for MySQL anyway, but, I can't fault them for not wanted to work with a company like Oracle. It is unfortunate that Oracle bought MySQL. Their .NET driver has sucked for years.

[myusrn]

The vscode extensions marketplace has a few mysql / mariadb" extension options. One of them with over 500k installs and 4 star rating arising from 28 user submissions and the other with over 94k installs and 5 star rating arising from 27 submissions. That said i gave them both a try and they seems to work okay albeit without the all the fit and finish of the microsoft provided sql server extension support. For example the 500k installs one seems to require a 'use db_name;' statement included with every batch of statements you execute where as the 94 installs one caches whatever the most recent 'use db_name;' call setup.

q1. Why can't we just have one of those vscode mysql / mariadb extensions surfaced in the azure data studio extensions marketplace and be on our way with this request for azure data studio mysql / mariadb support?

q2. If vscode as sql server, mysql / mariadb and jupyter notebook support what's the primary differentiator / objective of the separate vscode sources derived azure data studio offering?

[jvg-odchc]

👍

[yahorsi]

Nothing changed in the mid of 2021, MySql is still most popular database and we desperately need Azure Data Studio to support it

[jemiller0]

They aren't doing it on purpose for business reasons. Just like Oracle has dragged their feet on releasing an Entity Framework Core driver for years.

[yahorsi]

@jemiller0 I don't see the point as they added support for the Postgres

[jemiller0]

I don't know what kind of driver ADS uses. One written in Typescript? PostgreSQL has a higher quality .NET driver than Oracle MySQL IMHO. Not sure if there is a similar issue with Typescript. Probably, Microsoft doesn't have the same bad blood/competitiveness with PostgreSQL that they do with Oracle.

[myusrn]

Given we now have mariadb open source variant of mysql supporting that in ads would be more about embracing open source solutions than oracle specific ones.

[jemiller0]

Microsoft is a for profit corporation. The only thing that matters to them is if they make more money. If they don't think it will help them do that, then, they won't do it. Or, they will intentionally withhold the functionality, even if it exists, if they think it is against their business interests. It is obvious that that is what they are doing. They demoed support for this years ago and then apparently got cold feet. That's why you don't see a single response from Microsoft on this issue even though there are probably hundreds of people if not more asking for this.

[noahbroyles]

@jemiller0 Heck, I mean it's not even that hard to add MySQL support. Why can't Microsoft just be a homie for once? 🙄

[firanto]

@jemiller0 Sure. Probably they forgot that they also sell MySql in their Azure Database Services. I guess everyone using this particular service are not considered customer apparently. 🙄

[eilerth]

I check back here every once in awhile with hopes that I can start using Azure Data Studio for MySQL. I figured I'd finally try to get my voice heard in hopes that it makes some difference (I know, I can be quite naïve sometimes).

I'm not convinced there are competitive/profit motives for it not getting implemented, but I can see why that's an easy conclusion to come to, because... well... This is the number 1 voted feature request for the product here on github, and it has been for literally years now, and there has been no communication with the community on if/when it'll get implemented.

And I think what can add even more to the community's frustration is that we were teased pretty hard core over two years ago in this post: https://cloudblogs.microsoft.com/sqlserver/2019/04/18/the-april-release-of-azure-data-studio-is-now-available/

Excerpt:

With the excitement for PostgreSQL support, this makes Azure Data Studio officially a multi-database tool. As a result, we’re curious to hear what other databases the community is looking for. Currently, we have the following tracking requests. If one of these databases listed interests you, please leave a thumbs up on the issue.

So that was over 2 years ago now, and that kind of tease is pretty low.

I remain optimistic, though, and will probably be back to this page in a couple months hoping for at least an indication of if/when I could expect this.

The silence is the worst part. If I could get a "Yeah, we're not getting to this for at least a couple years" or "Actually, we've dropped plans to do this, but that's not to say that could change in the future."

Just some expectation setting for the most requested feature that was teased to the community two years ago would be nice.

[24mu13]

Just for my understanding, theoretically, is it possible to trigger a PR with MySQL support to ADS ?

I could even understand MS would not invest money on that, but that's the good side of open source, opening the code to the community, right ?

[noahbroyles]

Heck yeah it's possible, but I don't know if they would accept it. If someone did make something like that they could just link it in a separate repo here in this issue.

[ghost]

Hi @sbehara1 I think like other people in the comments, we need to have the connection to different databases like MySQL, PostgreSQL, and Oracle. I really like to use ADS, and I don't want to have a lot of software to use my connection to the databases. Thank you very much for your effort here, and we really appreciate it if you can give us an update here.

[temujim]

This is a a good selling point for anyone to start to tinker with Azure products, those who's been on mysql and has been hosting their servers for years outside AWS, Azure or GCP... For a brief time after seeing the features of AzureDataStudio, I actually considered of moving my servers to Azure ... I just need the VIM keys while doing SQL queries...

[darkguy2008]

So I came here from the same April release link ( https://cloudblogs.microsoft.com/sqlserver/2019/04/18/the-april-release-of-azure-data-studio-is-now-available/ ) and installed it thinking it now has support for MySQL, just to notice it's just a feature request and that it hasn't moved for years. One begins to wonder where's the priorities, but it seems that it's made on purpose to make potential users of the tool move to MSSQL databases instead of other alternatives that sometimes we're forced to work with.

Sucks though, this just shows that it doesn't matter if an issue is the highest voted one, MS just won't listen like they say they do.

[jemiller0]

That's cloud in a nutshell. Designed to make corporations like Microsoft and Amazon more money, not to make things easier.

[kakins]

Probably best to leave all of the insulting and derogatory comments out of the discussions.

1. They won't get you what you want
2. Be reminded this is a free tool they're giving you anyways (along with the other free tools MS provides) -- You're not owed anything.
3. If you're that passionate about it, why not investigate writing an extension or something?

[jemiller0]

Please refrain from clogging up the comments section with useless tone policing statements in support of the corporate overlords. It's not a productive use of anyone's time.