MSSQL with ChatGPT: How to Analyze your Microsoft SQL Server Data with AI

Introduction

Hi, I'm Dave from Notable, and today let's learn how to use Notable's ChatGPT plugin to query a Microsoft SQL database. This guide will take you step-by-step through the process, starting from database connection setup to querying and visualizing data using ChatGPT.

Step 1: Connecting Notable to Microsoft SQL Database

First, we need to connect Notable to our Microsoft SQL database.

Open Notable: Navigate to the notebook page.
Database Icon: On the left, click the database icon to manage data connections.
Add Data Connection: Click "Add Data Connection" and fill in the details.
- Name: Give your connection a name, for example, "MsSQL Demo Database".
- Details: Enter the hostname, port, username, password, and the database name.
Connection Type: Choose between a private data connection or a space-level data connection.
- Private Connection: Accessible only to you.
- Space-level Connection: Shared with your team in the same space.
Create Connection: Click "Create" to save the connection.

Step 2: Integrate with ChatGPT

ChatGPT Plus Subscriber: Ensure you're a ChatGPT Plus subscriber using the GPT-4 model and have enabled the beta plugin feature.
Install Notable Plugin: Go to the plugin store, find Notable, and click install.
Create Notebook: Ask ChatGPT to create a notebook to query data within your new MsSQL connection.
```
I want to create a notebook to query data within my MsSQL demo data connection.
```
Follow Progress: Watch the green bar indicating progress and wait for responses.

Step 3: Querying Data with ChatGPT

Fetch Available Data Sources: Confirm data sources by creating SQL cells and checking the connections.

Add Explanations: Always ask ChatGPT to write markdown cells for better understanding.

When writing in this notebook, always use markdown cells to provide an explanation of the code cells so I can better understand what you're doing.

Example Queries:

Unique Species of Sharks:

I am interested in data contained in the sharks table. How many unique species of sharks are in the table, and what are they?

Most Tagged Shark Species:

What species of shark had the most individual tags?

Largest Geographic Box:

Which shark has the largest geographic box (from min lat/long to max lat/long)?

Detailed Visualization:

Use folium to plot the first ping, last ping, and a line connecting each ping for a tiger shark named Emma. Use a play icon for the first ping and a stop icon for the last ping.

Step 4: Using Advanced Features

Handling Errors: ChatGPT can self-correct syntax errors and retry.
Mixing SQL and Python: Use SQL to fetch data and Python (like the Folium library) to visualize it.
Rich Visualizations: Notable can turn data frames into rich, interactive visualizations without custom code.

Conclusion

Utilize Notable’s integration with ChatGPT for seamless natural language querying and analysis of your Microsoft SQL data. This powerful combination can enhance both productivity and collaborative analytics within your team.

For further help, visit community.notable.io or contact support at support.notable.io.

Keywords

Notable
ChatGPT
Microsoft SQL
Data Connection
Query
Visualization
Plugins
SQL
Python
Folium

FAQ

What is Notable?
- Notable is a platform that allows for collaborative data analysis and visualization.
How do I connect Notable to a Microsoft SQL database?
- Follow the steps to add a data connection, including filling in hostname, port, username, password, and database name.
Do I need a ChatGPT Plus subscription to use the plugin?
- Yes, a ChatGPT Plus subscription is needed to use the GPT-4 model and the beta plugin feature.
Can I share my SQL data connection with my team?
- Yes, by choosing a space-level data connection, it can be shared with your team within the same space.
What types of visualizations can I create in Notable?
- Notable supports over 40 different visualization types, including tile maps, interactive maps, and more.
Can ChatGPT correct its own errors?
- Yes, if ChatGPT encounters a syntax error, it can attempt to correct itself and retry the query.

By following the steps outlined above, you will be well-equipped to leverage ChatGPT's capabilities to analyze and visualize your Microsoft SQL Server data efficiently. Happy querying!