Database Connectors
Supported database connectors
AI2SQL currently supports connections to MySQL, SQL Server, PostgreSQL, Big Query, Redshift, Snowflake, Mongodb databases. Users can seamlessly integrate these databases with AI2SQL to generate SQL queries using natural language text.
Setting up database connections (MySQL, SQL Server, or PostgreSQL)
Navigate to the "Connectors" section from the main menu.
Click the "Add Connector" button to open the database connection setup dialog.
Select the desired database type (MySQL, SQL Server, or PostgreSQL) and provide the necessary connection information, such as hostname, port, username, and password.
Provide Connection Information
Hostname or IP address: Enter the server name or IP address where the database is hosted. Make sure it's accurate and reachable from your network. If possible, use the IP address instead of the DNS name to avoid resolution issues.
If your database server is hosted on your local machine or within your private network, entering "localhost" or a private IP address (e.g., 192.168.x.x) might not work if the AI2sql platform is hosted externally. In such cases, you may need to set up port forwarding or use a VPN/SSH tunnel to securely expose your database server to the internet.
Port: Provide the port number on which your database server is listening for connections. This value is usually the default port for your chosen database type (e.g., 3306 for MySQL, 5432 for PostgreSQL, 1433 for SQL Server).
Database Name: Enter the name of the database you want to connect to. Ensure that it's spelled correctly and case-sensitive, if applicable.
Authentication: Select the appropriate authentication method (e.g., username/password) based on your database server's configuration.
Username: If using username/password authentication, enter the username with the necessary privileges to access the database.
Password: If using username/password authentication, enter the password associated with the provided username.
Note: If the direct connection to your database does not work for you, as an alternative, you can add your DDL (Data Definition Language) script to AI2sql. This way, you can still use our platform to generate SQL queries without directly connecting to your database. Follow the guide below to learn how to add your DDL script to AI2sql:
Setting up MongoDB Connectors
Introduction
AI2SQL MongoDB connectors enable users to interact with MongoDB databases seamlessly. This help document guides users on how to provide their MongoDB credentials, including those from MongoDB Atlas, to connect with the AI2SQL platform.
Prerequisites
To use the AI2SQL MongoDB connectors, you must have the following:
Access to the AI2SQL platform
MongoDB server with valid credentials (host, port, username, password, and database) or MongoDB Atlas account
Connecting to MongoDB using AI2SQL
To connect to MongoDB using AI2SQL, follow these steps:
Log in to the AI2SQL platform with your username and password.
Navigate to the MongoDB connector section.
Enter your MongoDB credentials in the respective fields:
Host: The server address or domain where your MongoDB instance is running.
Port: The port number on which your MongoDB instance is listening (default is 27017).
Username: Your MongoDB username with appropriate permissions.
Password: Your MongoDB password associated with the username.
Database: The name of the MongoDB database you want to connect to.
Click on the "Connect" button to establish a connection with your MongoDB instance.
If the connection is successful, you will see a "Connection established" message. If there is an issue with the connection, you will receive an error message with details about the problem. Check your MongoDB credentials and try again.
Once connected, you can use the AI2SQL MongoDB connectors to fetch collections, query data, and perform other database-related tasks.
Getting MongoDB Atlas Connection Details
If you are using MongoDB Atlas, follow these steps to obtain your connection details:
Log in to your MongoDB Atlas account.
Navigate to the "Clusters" section.
Click on the "Connect" button for the cluster you want to connect to.
Choose "Connect your application."
Select "Python" as the driver and choose the appropriate version.
Copy the connection string provided. It should look like this:
mongodb+srv://<username>:<password>@cluster0.mongodb.net/myFirstDatabase?retryWrites=true&w=majority
Replace <username> and <password> with your MongoDB Atlas username and password, respectively.
Extract the following details from the connection string:
Host: The server address or domain (e.g., cluster0.mongodb.net)
Port: For MongoDB Atlas, the port is included in the connection string and is usually 27017.
Username: Your MongoDB Atlas username
Password: Your MongoDB Atlas password
Database: The database you want to connect to (replace myFirstDatabase with the desired database name)
Enter these details in the AI2SQL MongoDB connector form, as described in Section 3, and click "Connect."
Troubleshooting and FAQs
Q: I cannot connect to my MongoDB instance. What should I do?
A: Check your MongoDB credentials and ensure that your MongoDB instance is running and accessible. Verify that your MongoDB server is allowing connections from the AI2SQL platform's IP address.
Q: I received an authentication error. How can I resolve it?
A: Ensure that your MongoDB username and password are correct, and the user has the necessary permissions to connect to the specified database.
Contacting Support
If you encounter any issues while using the AI2SQL MongoDB connectors or need assistance with the configuration and setup, please don't hesitate to contact the AI2SQL support team. They can provide guidance and help troubleshoot any problems you may be experiencing.
To contact the AI2SQL support team, you can:
Send an email to support@ai2sql.io with a detailed description of your issue or question. Please include any error messages, screenshots, or relevant information that can help diagnose the problem.
Visit the AI2SQL support and submit a support ticket. Make sure to provide as much information as possible about the issue you're facing.
Reach out through the AI2SQL community forum (replace with your actual community forum URL), where you can ask questions and receive help from other users as well as the support team.
The AI2SQL support team will respond as quickly as possible to help you resolve any issues and ensure a smooth experience with the MongoDB connectors.
Generating SQL queries for connected databases
In the AI2SQL Workspace, click the "Connectors" dropdown and select the desired database connection.
Type a natural language query related to the data in the connected database.
Click the "Generate SQL" button to convert your query into an SQL query tailored to the selected database connection.
Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist
Follow this comprehensive checklist to ensure that your AI2sql connector settings are correctly configured and resolve any issues you may encounter while connecting to your database.
Verify your database credentials
Ensure that the username, password, and host address are correct and up-to-date.
Confirm that your user account has the necessary privileges to access the database.
Check your database server
Verify that your database server is up and running.
Ensure that your database server is not experiencing any network issues or undergoing maintenance.
Confirm the AI2sql connector compatibility
Make sure you are using the correct AI2sql connector that is compatible with your specific database (e.g., MySQL, PostgreSQL, SQL Server.).
Update the connector to the latest version if needed.
Examine your configuration settings
Revisit your AI2sql configuration settings and ensure that they are correct.
Double-check the connection string or URL for any typos or incorrect values.
Use the IP address instead of the DNS name when entering the host address.
Inspect your firewall settings
Verify that your firewall is not blocking the AI2sql connector's access to your database server.
Add the AI2sql connector to your firewall's whitelist, if necessary. (52.151.220.76)
Check database firewall and reachable address
Ensure that the database firewall settings are not preventing access to the server.
Confirm that the address entered is correct and reachable from the client machine.
Review your error logs
Carefully review the error logs to identify any specific issues or error codes.
Search for solutions to the specific error codes you find, or reach out to our support team with the error details.
If you have gone through the checklist and are still experiencing issues, please contact our support team at with the details of the problem, including any error messages or logs. Our team will be more than happy to assist you in resolving the issue.
Note: If the direct connection to your database does not work for you, as an alternative, you can add your DDL (Data Definition Language) script to AI2sql. This way, you can still use our platform to generate SQL queries without directly connecting to your database. Follow the guide below to learn how to add your DDL script to AI2sql:
Requesting new database connectors
If you need support for additional database connectors, you can the AI2SQL team with your request. AI2SQL is continuously working to expand its supported database connectors to accommodate diverse user needs and preferences.
System Security Overview
Our System's Security We take the security of your data very seriously. We have implemented several measures to ensure the protection of your data while using our services. This document provides an overview of the security features in our system.
Infrastructure Security
We host our application on Microsoft Azure, a trusted and reliable cloud platform. Microsoft Azure offers industry-leading security measures, ensuring that our infrastructure is protected from potential threats. By leveraging Azure's robust security features, we can provide a secure and stable environment for our application and your data.
Secure Connections
We use secure connections to transmit data between your device and our servers. All data transferred over the network is encrypted using industry-standard encryption algorithms to protect it from eavesdropping and tampering.
Connection Management
Our system allows users to create connections to their databases. These connections are stored in memory, associated with the authenticated user. This ensures that only the user who created the connection can access the resources related to it.
Limited Data Access
Our system is designed to fetch only the schema information about your database tables and columns. We do not access, manipulate, or store any of your actual data. This limited access ensures that your sensitive data remains private and secure while using our services.
Please feel free to contact us if you have any questions or concerns about our system's security. We are always here to help. support@ai2sql.io
AI2SQL currently supports connections to MySQL, SQL Server, PostgreSQL, Big Query, Redshift, Snowflake, Mongodb databases. Users can seamlessly integrate these databases with AI2SQL to generate SQL queries using natural language text.
Setting up database connections (MySQL, SQL Server, or PostgreSQL)
Navigate to the "Connectors" section from the main menu.
Click the "Add Connector" button to open the database connection setup dialog.
Select the desired database type (MySQL, SQL Server, or PostgreSQL) and provide the necessary connection information, such as hostname, port, username, and password.
Provide Connection Information
Hostname or IP address: Enter the server name or IP address where the database is hosted. Make sure it's accurate and reachable from your network. If possible, use the IP address instead of the DNS name to avoid resolution issues.
If your database server is hosted on your local machine or within your private network, entering "localhost" or a private IP address (e.g., 192.168.x.x) might not work if the AI2sql platform is hosted externally. In such cases, you may need to set up port forwarding or use a VPN/SSH tunnel to securely expose your database server to the internet.
Port: Provide the port number on which your database server is listening for connections. This value is usually the default port for your chosen database type (e.g., 3306 for MySQL, 5432 for PostgreSQL, 1433 for SQL Server).
Database Name: Enter the name of the database you want to connect to. Ensure that it's spelled correctly and case-sensitive, if applicable.
Authentication: Select the appropriate authentication method (e.g., username/password) based on your database server's configuration.
Username: If using username/password authentication, enter the username with the necessary privileges to access the database.
Password: If using username/password authentication, enter the password associated with the provided username.
Note: If the direct connection to your database does not work for you, as an alternative, you can add your DDL (Data Definition Language) script to AI2sql. This way, you can still use our platform to generate SQL queries without directly connecting to your database. Follow the guide below to learn how to add your DDL script to AI2sql:
Setting up MongoDB Connectors
Introduction
AI2SQL MongoDB connectors enable users to interact with MongoDB databases seamlessly. This help document guides users on how to provide their MongoDB credentials, including those from MongoDB Atlas, to connect with the AI2SQL platform.
Prerequisites
To use the AI2SQL MongoDB connectors, you must have the following:
Access to the AI2SQL platform
MongoDB server with valid credentials (host, port, username, password, and database) or MongoDB Atlas account
Connecting to MongoDB using AI2SQL
To connect to MongoDB using AI2SQL, follow these steps:
Log in to the AI2SQL platform with your username and password.
Navigate to the MongoDB connector section.
Enter your MongoDB credentials in the respective fields:
Host: The server address or domain where your MongoDB instance is running.
Port: The port number on which your MongoDB instance is listening (default is 27017).
Username: Your MongoDB username with appropriate permissions.
Password: Your MongoDB password associated with the username.
Database: The name of the MongoDB database you want to connect to.
Click on the "Connect" button to establish a connection with your MongoDB instance.
If the connection is successful, you will see a "Connection established" message. If there is an issue with the connection, you will receive an error message with details about the problem. Check your MongoDB credentials and try again.
Once connected, you can use the AI2SQL MongoDB connectors to fetch collections, query data, and perform other database-related tasks.
Getting MongoDB Atlas Connection Details
If you are using MongoDB Atlas, follow these steps to obtain your connection details:
Log in to your MongoDB Atlas account.
Navigate to the "Clusters" section.
Click on the "Connect" button for the cluster you want to connect to.
Choose "Connect your application."
Select "Python" as the driver and choose the appropriate version.
Copy the connection string provided. It should look like this:
mongodb+srv://<username>:<password>@cluster0.mongodb.net/myFirstDatabase?retryWrites=true&w=majority
Replace <username> and <password> with your MongoDB Atlas username and password, respectively.
Extract the following details from the connection string:
Host: The server address or domain (e.g., cluster0.mongodb.net)
Port: For MongoDB Atlas, the port is included in the connection string and is usually 27017.
Username: Your MongoDB Atlas username
Password: Your MongoDB Atlas password
Database: The database you want to connect to (replace myFirstDatabase with the desired database name)
Enter these details in the AI2SQL MongoDB connector form, as described in Section 3, and click "Connect."
Troubleshooting and FAQs
Q: I cannot connect to my MongoDB instance. What should I do?
A: Check your MongoDB credentials and ensure that your MongoDB instance is running and accessible. Verify that your MongoDB server is allowing connections from the AI2SQL platform's IP address.
Q: I received an authentication error. How can I resolve it?
A: Ensure that your MongoDB username and password are correct, and the user has the necessary permissions to connect to the specified database.
Contacting Support
If you encounter any issues while using the AI2SQL MongoDB connectors or need assistance with the configuration and setup, please don't hesitate to contact the AI2SQL support team. They can provide guidance and help troubleshoot any problems you may be experiencing.
To contact the AI2SQL support team, you can:
Send an email to support@ai2sql.io with a detailed description of your issue or question. Please include any error messages, screenshots, or relevant information that can help diagnose the problem.
Visit the AI2SQL support and submit a support ticket. Make sure to provide as much information as possible about the issue you're facing.
Reach out through the AI2SQL community forum (replace with your actual community forum URL), where you can ask questions and receive help from other users as well as the support team.
The AI2SQL support team will respond as quickly as possible to help you resolve any issues and ensure a smooth experience with the MongoDB connectors.
Generating SQL queries for connected databases
In the AI2SQL Workspace, click the "Connectors" dropdown and select the desired database connection.
Type a natural language query related to the data in the connected database.
Click the "Generate SQL" button to convert your query into an SQL query tailored to the selected database connection.
Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist
Follow this comprehensive checklist to ensure that your AI2sql connector settings are correctly configured and resolve any issues you may encounter while connecting to your database.
Verify your database credentials
Ensure that the username, password, and host address are correct and up-to-date.
Confirm that your user account has the necessary privileges to access the database.
Check your database server
Verify that your database server is up and running.
Ensure that your database server is not experiencing any network issues or undergoing maintenance.
Confirm the AI2sql connector compatibility
Make sure you are using the correct AI2sql connector that is compatible with your specific database (e.g., MySQL, PostgreSQL, SQL Server.).
Update the connector to the latest version if needed.
Examine your configuration settings
Revisit your AI2sql configuration settings and ensure that they are correct.
Double-check the connection string or URL for any typos or incorrect values.
Use the IP address instead of the DNS name when entering the host address.
Inspect your firewall settings
Verify that your firewall is not blocking the AI2sql connector's access to your database server.
Add the AI2sql connector to your firewall's whitelist, if necessary. (52.151.220.76)
Check database firewall and reachable address
Ensure that the database firewall settings are not preventing access to the server.
Confirm that the address entered is correct and reachable from the client machine.
Review your error logs
Carefully review the error logs to identify any specific issues or error codes.
Search for solutions to the specific error codes you find, or reach out to our support team with the error details.
If you have gone through the checklist and are still experiencing issues, please contact our support team at with the details of the problem, including any error messages or logs. Our team will be more than happy to assist you in resolving the issue.
Note: If the direct connection to your database does not work for you, as an alternative, you can add your DDL (Data Definition Language) script to AI2sql. This way, you can still use our platform to generate SQL queries without directly connecting to your database. Follow the guide below to learn how to add your DDL script to AI2sql:
Requesting new database connectors
If you need support for additional database connectors, you can the AI2SQL team with your request. AI2SQL is continuously working to expand its supported database connectors to accommodate diverse user needs and preferences.
System Security Overview
Our System's Security We take the security of your data very seriously. We have implemented several measures to ensure the protection of your data while using our services. This document provides an overview of the security features in our system.
Infrastructure Security
We host our application on Microsoft Azure, a trusted and reliable cloud platform. Microsoft Azure offers industry-leading security measures, ensuring that our infrastructure is protected from potential threats. By leveraging Azure's robust security features, we can provide a secure and stable environment for our application and your data.
Secure Connections
We use secure connections to transmit data between your device and our servers. All data transferred over the network is encrypted using industry-standard encryption algorithms to protect it from eavesdropping and tampering.
Connection Management
Our system allows users to create connections to their databases. These connections are stored in memory, associated with the authenticated user. This ensures that only the user who created the connection can access the resources related to it.
Limited Data Access
Our system is designed to fetch only the schema information about your database tables and columns. We do not access, manipulate, or store any of your actual data. This limited access ensures that your sensitive data remains private and secure while using our services.
Please feel free to contact us if you have any questions or concerns about our system's security. We are always here to help. support@ai2sql.io
Updated on: 07/10/2023
Thank you!