> ## Documentation Index
> Fetch the complete documentation index at: https://docs.myquery.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Sources

## **1. Managing Database Connections**

The main **Database** page lists all your active connections. From here, you can:

* **Add New Connection:** Connect a new Data Source. The system will guide you through entering your credentials (Host, Port, User, Password).
* **Security First:** MyQuery uses **schema-only** access. We never store your raw data on our servers; we only encrypt and store the "map" (schema) so the AI knows how to answer your questions.
* **Edit Connections:** Update connection strings or rename your database display names if your infrastructure changes.
* **Remove Data Sources:** Disconnect databases that are no longer needed.

***

## **2. Manage Tables: The Command Center**

By selecting **Manage Tables** from any database card, you enter a specialized workspace for organizing your data.

### **Schema Explorer (Sidebar)**

On the left, you can quickly jump between different connected databases and browse all available tables. Click any table to open its detailed management view.

### **Table Configuration (Header)**

Once a table is selected, you can control its visibility and how the AI understands it:

* **Table Status:** Toggle a table between **Active** and **Inactive**. Inactive tables are hidden from the AI Chat, keeping your workspace clean.
* **AI Context (Description):** Click the **Edit** icon to provide a natural language description for the table (e.g., *"This table contains all customer transaction data since 2021"*). This significantly improves the AI's accuracy when answering questions.

***

## **3. Investigating Your Tables**

The table management area features two powerful views to help you audit and understand your data:

### **Columns View**

This view shows the "blueprint" of your table:

* **Schema Details:** View a list of every column, its data type (e.g., Integer, Varchar), and its current description.
* **Searchable Toggle:** You can decide if specific columns should be "Searchable." Turning this on tells the AI that this column is important for filtering and finding records.
* **Column Documentation:** Just like tables, you can edit descriptions for individual columns to clarify what specific fields mean (e.g.,

### **Data View (Raw Interaction)**

Need to see exactly what's inside the table? Switch to the **Data** tab for a high-performance spreadsheet experience:

* **Live Preview:** Browse real rows from your database in real-time.
* **Searching & Filtering:** Use the header search bar or the advanced **Filter** button to narrow down rows based on complex logic.
* **Ordering:** Click any column header to sort the data instantly.
* **Pagination:** Effortlessly navigate through large tables with millions of rows using the page controls at the bottom.
* **Column Visibility:** Hide or show specific columns to focus only on the data points that matter to you.

***

## **Configuration Tips**

* **Refresh Schema:** If you add a new column to your database, use the **Refresh** button in the Table Selector to update MyQuery’s map.
* **Less is More:** Only activate the tables you actually need for your reports. This makes the AI faster and reduces the chance of ambiguous answers.
* **M2M Tables:** Many-to-Many relationship tables are automatically detected and don't count against your plan's table limits!