Microsoft SQL Server (MS SQL)

Follow this guide to connect your Microsoft SQL Server to Wobby and start building agents on top of your data.

To connect your Microsoft SQL Server database to Wobby, you’ll need to:

1. Create a login and user in your SQL Server.

2. Grant the necessary read-only permissions.

3. Allow Wobby’s IP address through your firewall or network rules.

4. Set up the connection in the Wobby interface.

⚠️ Wobby’s agents only run read-only queries on your data. Write permissions are never used.

---

1. Create Login and User in SQL Server

You’ll need to create a server-level login and a database-level user that Wobby can use to connect. The following SQL script sets up a read-only user for Wobby:

-- Replace placeholder values with your actual database, schema, and password.

-- Create server-level login
CREATE LOGIN wobby_login WITH PASSWORD = '<your_secure_password>';

-- Switch to your target database
USE YourDatabaseName;

-- Create a database-level user linked to the login
CREATE USER wobby_user FOR LOGIN wobby_login;

-- Grant read-only access to all tables
ALTER ROLE db_datareader ADD MEMBER wobby_user;

✅ The db_datareader role gives read-only access to all current and future tables in the database.

3. Allow Wobby’s IP Address

If your SQL Server is behind a firewall or uses network policies, make sure to allow inbound traffic from Wobby’s static IP:

34.77.172.158

This is required for Wobby’s agents to access your database.

4. Set Up the Connection in Wobby

1. Go to Wobby → Data Sources.

2. Click New MS SQL Connection.

3. Fill in the following details:

   • Host: your SQL Server address

   • Port: typically 1433

   • Database name: the one where wobby_user has access

   • Username: wobby_login

   • Password: the password you defined earlier

4. Test the connection and save.