Databases Searching Tool

Databases Searching Tool 

Is a powerful and efficient web application designed for advanced database searching within SQL Server environments.

This tool facilitates detailed and customizable searches across multiple databases, tables, and columns, streamlining the process of locating specific data within your SQL Server infrastructure.

Key Features

1. Comprehensive Search Capabilities:

   • Search for specific values across all databases or limit searches to selected databases.
   • Utilize wildcard searches with the '%' sign for partial matches.
   • Define specific tables and columns to focus searches, enhancing precision and efficiency.

2. User-Friendly Interface:

   • Simple and intuitive web interface built with Flask and Bootstrap, ensuring ease of use.
   • Real-time feedback and status updates during searches.

3. Advanced Session Management:

   • Retain session information including server credentials and search parameters for a seamless user experience.
   • Secure handling of user credentials and search configurations.

4. Dynamic and Flexible Search Configurations:

   • Toggle options for including or excluding specific databases, tables, and columns.
   • Input multiple database names, table names, and column names using comma-separated values for batch operations.

5. Robust Backend Integration:

   • Utilizes pyodbc for robust database connections and operations.
   • Efficiently handles large datasets and complex queries.

6. Result Management and Pagination:

   • Display search results in a structured table format.
   • Pagination controls for easy navigation through large sets of results.
   • Group and count occurrences of specific values for quick analysis.

Technical Specifications

• Framework: Flask (Python)
• Operating System: Windows
• Database Connectivity: ODBC Driver 17
• Server Management: Waitress for WSGI server
• Frontend: HTML, CSS (Bootstrap), JavaScript (jQuery)
• Logging and Error Handling: Comprehensive logging with traceback for error diagnostics
• Deployment Options:
  • Local deployment for offline use
  • Internet deployment for remote access

To ensure the proper functioning of the Databases Searching Tool, you must install the ODBC Driver 17 for SQL Server on your system.

How to Use

1. Server Configuration:

   • Start the server either locally or for internet access by running the application script.
   • Follow the prompts to select deployment mode and configure the server port.

2. Accessing the Application:

   • Open the provided URL in your web browser to access the D.S.T interface.

3. Performing a Search:

   • Enter SQL Server credentials (server, user, password).
   • Specify the search value and adjust additional search options (use percent, specific databases, tables, and columns).
   • Click 'Search' to initiate the search operation.
   • View and navigate through results using the provided table and pagination controls.

Security and Privacy

Databases Searching Tool prioritizes the security and privacy of user data. All user credentials are handled securely, and sensitive information is never exposed. Session management ensures a secure and personalized user experience, retaining necessary information only for the duration of the session.