[ChatGPT](https://openai.com/blog/chatgpt/) is truly impressive. You can instruct it to do all sorts of things when they can be communicated in plain text. Software developers are already using it to [write code](https://twitter.com/alejandro_du/status/1611782993617604611) or [improve SQL queries](https://twitter.com/alejandro_du/status/1603079060648869888), among many other things. 

\
But ChatGPT can also act as software. For example, if you tell it the following:

\
**Act as the MariaDB command line tool. Only reply to commands with output in one single code block. Do not write any explanations. Expect English messages in {curly brackets}. My first command is SELECT VERSION();**

\
Then you'll get this answer:

[ \n  ![](https://cdn.hackernoon.com/images/RLmwLcqcgCQhlcbhuqLdzf7ASis1-2023-01-12T21:24:58.117Z-clctlmzye000j0as64w86cnhh)](https://blogger.googleusercontent.com/img/a/AVvXsEiReXjwip3GHCmhY3KfWhkpPo4Ci2Fs7Ss2msuMzhtUumiOGP4BvDaw5ivSwRRyCKPaNgExibvSXc_lkhGwiD20PWJVENj4TWhYazZZOA-1q0YBtud2pfdHbX22DSpOj_LCumEOQnivp-NOva-VXVsOix6Oe_UtTebz8R5FfVxzm3nfD9CM3-AFK2cZ)

Isn't that impressive? There. Now you have a new way to get started with MariaDB without installing anything. I mean, that was even faster than [using Docker on your browser](https://dzone.com/articles/learn-database-read-write-splitting-using-your-bro)!

\
Let's show the available databases (or schemas):

\
```sql
SHOW DATABASES;
```

[  ![](https://cdn.hackernoon.com/images/RLmwLcqcgCQhlcbhuqLdzf7ASis1-2023-01-12T21:24:58.121Z-clctlmzyh000k0as6aqdf1bs7)](https://blogger.googleusercontent.com/img/a/AVvXsEgbk3kN2S3cCLjJq7TIIRM9Uzo4Wa7PKk8u1c6IIdJ5wGfGeQRZTLbzHgTpERyKyONihtwvJFpTEUNGVNQ7eA_RK7O785D_67fKhieeSMu3Sxl3Iwoyab3WDBPUmQoLdHE3WStyOljG0F8iF-tATEEEdwCqNoqIu20m2SCoPjaGK-Nygech8q-UbIjL)

Can we create a new database?

\
```sql
CREATE DATABASE test;
```

[  ![](https://cdn.hackernoon.com/images/RLmwLcqcgCQhlcbhuqLdzf7ASis1-2023-01-12T21:24:58.122Z-clctlmzyi000l0as67ratas0a)](https://blogger.googleusercontent.com/img/a/AVvXsEg7FU_VKCUaMTbrXTri9Sh4mFnkrS6oTANi2bpLeARESnqrloFHERmSa1IBR-kkxwd7W8mE_zuy_y4AAvVBDuFEXHHRLRptr4kugXpiJX5LK-gDZkdMWx04guDfxIVbbc2fBUVxTFe-4R0LCr_abrREVIYwVay6UTXNMm-BfMcua5_h1YQB-OQAA0wT)

Yes, we can! How about creating a new table and inserting data?

\
```sql
CREATE TABLE test.messages(content TEXT);
INSERT INTO test.messages VALUES("Hi MariaDB 👋");
```

[  ![](https://cdn.hackernoon.com/images/RLmwLcqcgCQhlcbhuqLdzf7ASis1-2023-01-12T21:24:58.122Z-clctlmzyi000m0as6g22q066g)](https://blogger.googleusercontent.com/img/a/AVvXsEiP9HMvNJeOy6mga_Ix2s-D98-7BkaOsjBihxtXlnTx6t3JBd-Ep1-3GHKSRo0xqwUkau398g4wgl61Ib35cNMKlVtFR5XXwZ5BcjJLog1T6_FfOEJ7SACcqVuEMAHaToq9xkUT4FtXc-hVjq68eGJ6KU4KbivUZmdy_aM2lm0W1kElbO1le3Jw1Dwz)

Query OK, 1 row affected. It seems to be working! Let's double-check that the data is stored:

\
```sql
SELECT * FROM test.messages;
```

[  ![](https://cdn.hackernoon.com/images/RLmwLcqcgCQhlcbhuqLdzf7ASis1-2023-01-12T21:24:58.127Z-clctlmzyn000n0as66pc7asy9)](https://blogger.googleusercontent.com/img/a/AVvXsEgqnlsI6zmJ_Ve6z1-OGNBTAdZnC0ig5N9fQnOkJuHS0wZAxKj8h415M5VCnUr_XJs5YyHFckuhWBwGs9iy0mr-Ky85UD8nYky-OozpjNnO_-MzxwyA-Ap24WOJxeuIbspxbBHaKUb2Pg80z1HFmMJp6QXh1zv2hDaTIWo__u6ds1p99HHUMyxCYfiM)

Hi MariaDB 👋! This is so cool! Open a new tab in your browser, and [try it out](https://chat.openai.com/chat) to see it in action.

When you want to stop ChatGPT from acting like a MariaDB database, just tell it to do so:

\
```
{stop acting like mariadb}
```

\
Or simply:

\
```javascript
{stop}
```

\


2022 - HackerNoon Contributor of the Year - Analytics

2022 - HackerNoon Contributor of the Year - Database

2022 - HackerNoon Contributor of the Year - Docker

2022 - HackerNoon Contributor of the Year - Git

2022 - HackerNoon Contributor of the Year - Java

2022 - HackerNoon Contributor of the Year - Sql

Visit my personal Blog!

Nominated for 2022 - HackerNoon Contributor of the Year - Database

Nominated for 2022 - HackerNoon Contributor of the Year - Git

Nominated for 2022 - HackerNoon Contributor of the Year - Java

Nominated for 2022 - HackerNoon Contributor of the Year - Docker

Nominated for 2022 - HackerNoon Contributor of the Year - Sql

Nominated for 2022 - HackerNoon Contributor of the Year - Analytics

Too Long; Didn't Read

Get hands-on learning from ML experts on Coursera 

I Made ChatGPT Act as a MariaDB Database

I Made ChatGPT Act as a MariaDB Database

Too Long; Didn't Read

@alejandroduarte

RELATED STORIES