MCP SQL Agent

SQLite format 3

@ 
.c
5E�: c#5�k
�)tableMissionsMissionsCREATE TABLE Missions ( id INTEGER PRIMARY KEY, mission_type TEXT, start_date DATE, end_date DATE, unit_id INTEGER, description TEXT, FOREIGN KEY (unit_id) REFERENCES Units(id) )�=++
�1tableMaintenanceLogsMaintenanceLogsCREATE TABLE MaintenanceLogs ( id INTEGER PRIMARY KEY, equipment_id INTEGER, maintenance_date DATE, description TEXT, performed_by INTEGER, FOREIGN KEY (equipment_id) REFERENCES Equipment(id), FOREIGN KEY (performed_by) REFERENCES Personnel(id) )�T
�wtableEquipmentEquipmentCREATE TABLE Equipment ( id INTEGER PRIMARY KEY, type TEXT, status TEXT, unit_id INTEGER, acquisition_date DATE, FOREIGN KEY (unit_id) REFERENCES Units(id) )�
�tableUnitsUnitsCREATE TABLE Units ( id INTEGER PRIMARY KEY, name TEXT, base_id INTEGER, FOREIGN KEY (base_id) REFERENCES Bases(id) )j
�3tableBasesBasesCREATE TABLE Bases ( id INTEGER PRIMARY KEY, name TEXT, location TEXT )�8

�?tablePersonnelPersonnelCREATE TABLE Personnel ( id INTEGER PRIMARY KEY, first_name TEXT, last_name TEXT, rank TEXT, birthdate DATE, service_start DATE )
� �Q ������)USAG HumphreysAsia%Andersen AFBUSA7Naval Station NorfolkAsia)#Camp PendletonMiddle East
!Fort BraggAsia ������3
9th Marine Regiment#
SEAL Team 63
3rd Armored Cavalry)
101st Airborne
7
1st Infantry Division 2 ���x[>!����hB  � � � n I $����iD&����^; � � � ~ Y 7  � � � � X : (2)
!SubmarineDecommissioned2008-11-241
!TruckActive2008-08-27'0) !SubmarineDecommissioned2024-12-09#/)
!TankDecommissioned2008-04-21 .! !HelicopterActive2004-07-24 -# !RadarMaintenance2019-05-12(,!) !HelicopterDecommissioned2022-04-02!+#
!DroneMaintenance2002-01-18 *#
!F-16Maintenance2011-05-20#))
!F-16Decommissioned2014-01-04#()
!ShipDecommissioned2002-06-04)'!)
!HelicopterDecommissioned2010-11-16 &
!SubmarineActive2012-04-01$%)
!TruckDecommissioned2006-05-28#$)
!ShipDecommissioned2016-07-26!##
!TruckMaintenance2010-01-14#")
!F-16Decommissioned2013-03-16#!)
!TankDecommissioned2001-11-05  !DroneActive2000-08-16$)
!RadarDecommissioned2003-06-22
!ShipActive2004-11-07
!DroneActive2001-03-27
!TruckActive2012-08-01#)
!TankDecommissioned2003-05-28
!F-16Active2023-04-09 #
!TankMaintenance2022-07-08%#
!SubmarineMaintenance2022-11-19(!) !HelicopterDecommissioned2009-12-19)!)
!HelicopterDecommissioned2025-03-03#)
!TankDecommissioned2017-03-18#)
!TankDecommissioned2025-02-08
!TruckActive2019-08-05#)
!ShipDecommissioned2022-03-17$# !SubmarineMaintenance2025-03-23)!)
!HelicopterDecommissioned2012-06-28
!RadarActive2000-09-11 
!SubmarineActive2007-10-25$ )
!RadarDecommissioned2011-06-11 #
!F-16Maintenance2011-07-21&!#
!HelicopterMaintenance2016-03-24# )
!TankDecommissioned2020-02-20" ) !F-16Decommissioned2014-10-24$)
!TruckDecommissioned2003-02-03
!ShipActive2021-11-19
!F-16Active2001-08-02 !RadarActive2013-12-16!#
!TruckMaintenance2006-02-14 
!SubmarineActive2003-05-02# !ShipMaintenance2001-05-22
#
!ShipMaintenance2016-07-19
�� z ��}=��m. � � ^ ��F�f �  ; � � o /��[�>!!
ESupply2025-02-102025-02-24Supply operation in Region AN)!!
UReconnaissance2024-11-112024-11-19Reconnaissance operation in Region B>!!
ECombat2025-01-212025-01-29Combat operation in Region BN)!!
UReconnaissance2024-10-062024-10-16Reconnaissance operation in Region CB!!
ITraining2025-05-152025-05-17Training operation in Region B>!!
ESupply2024-08-252024-09-03Supply operation in Region B>!!
ECombat2025-06-192025-06-22Combat operation in Region CJ%!!
QHumanitarian2024-09-202024-09-28Humanitarian operation in Region C>!!
ESupply2025-04-012025-04-11Supply operation in Region CB!!
ITraining2025-06-262025-07-10Training operation in Region BM)!! UReconnaissance2025-04-022025-04-07Reconnaissance operation in Region AJ%!!
QHumanitarian2025-01-152025-01-16Humanitarian operation in Region BJ%!!
QHumanitarian2024-11-052024-11-19Humanitarian operation in Region CN)!!
UReconnaissance2025-03-302025-03-31Reconnaissance operation in Region CN)!!
UReconnaissance2024-08-262024-09-04Reconnaissance operation in Region C>!!
ECombat2025-05-262025-06-09Combat operation in Region B>!!
ECombat2024-07-302024-08-10Combat operation in Region CB !!
ITraining2025-03-302025-04-07Training operation in Region CN)!!
UReconnaissance2025-06-262025-06-27Reconnaissance operation in Region AB!!
ITraining2024-08-142024-08-17Training operation in Region BN )!!
UReconnaissance2025-04-102025-04-21Reconnaissance operation in Region B> !!
ESupply2024-12-092024-12-11Supply operation in Region C>!!
ECombat2025-01-132025-01-15Combat operation in Region B=!! ESupply2025-01-302025-02-03Supply operation in Region AB!!
ITraining2025-03-162025-03-30Training operation in Region A>!!
ESupply2024-10-312024-11-03Supply operation in Region AJ%!!
QHumanitarian2025-06-242025-07-06Humanitarian operation in Region C>!!
ESupply2025-02-262025-03-03Supply operation in Region CA!! ITraining2024-09-282024-10-01Training operation in Region C>
!!
ESupply2024-09-272024-10-10Supply operation in Region A Q���n;��wF � � � R $���`0��q@ � � ~ M  � � � [ )���l;��zI���\+���k;��{H���\)���k:
�
�
x
I
��-Q!!DavidBrownCorporal1993-03-192015-07-31.P!!RobertGarciaGeneral1981-02-012002-10-12.O!!CharlesSmithPrivate1999-07-052024-02-18-N!!RichardGarciaMajor1957-06-161979-04-27/M!!CharlesSmithCorporal1969-02-021992-09-12/L!!RichardSmithSergeant1984-09-222003-01-08,K!!JohnDavisSergeant1958-01-081981-09-180J!!CharlesJohnsonGeneral1963-03-051985-02-22/I!!JamesWilliamsCaptain1975-10-231995-05-18,H!!CharlesJonesMajor1988-03-262012-07-280G!!CharlesJohnsonColonel1950-04-281974-06-07.F!!CharlesDavisPrivate1997-05-072015-09-13,E!!RichardJonesMajor1952-01-221971-02-121D!!MichaelWilliamsPrivate1985-12-162010-06-24.C!!WilliamDavisCaptain1952-12-241977-04-050B!!!ThomasBrownLieutenant1996-11-212015-10-21.A!!RobertDavisSergeant1993-08-062017-01-13+@!!JohnSmithColonel1999-06-192019-02-21+?!!RobertDavisMajor1992-02-252016-10-281>!!!CharlesJonesLieutenant1982-02-242003-09-15*=!!JamesJonesMajor1986-05-082010-12-21,<!!DavidJonesColonel1970-02-151992-03-30/;!!JohnRodriguezGeneral1974-07-251994-09-083:!!!DavidRodriguezLieutenant1968-08-171988-05-09.9!!RichardDavisCaptain1972-02-181990-06-2908!!!JamesGarciaLieutenant1953-08-021973-01-15-7!!RobertDavisGeneral1962-04-041982-10-20.6!!ThomasJonesCorporal1954-07-081976-12-12-5!!JohnRodriguezMajor1955-07-051980-05-17/4!!CharlesBrownSergeant1969-02-281989-04-22.3!!ThomasJonesCorporal1959-09-201984-07-02,2!!JamesSmithCaptain1963-04-131985-10-1711!!MichaelWilliamsCaptain1958-11-261978-12-15,0!!JamesDavisColonel1951-09-141969-12-13,/!!JohnWilsonColonel1973-01-061995-12-16/.!!JosephGarciaSergeant1989-02-252009-02-27--!!JosephDavisPrivate1974-09-121998-11-250,!!WilliamRodriguezMajor1978-01-042000-09-16.+!!RobertWilliamsMajor1985-06-182005-09-24.*!!!JohnSmithLieutenant1967-02-091987-04-03/)!!MichaelJonesSergeant1982-08-072004-02-14,(!!JamesJonesCaptain1989-03-182010-08-23,'!!DavidJonesColonel1951-06-281971-06-26.&!!JosephJonesSergeant1956-01-261976-02-19/%!!MichaelGarciaCaptain1994-05-022016-02-130$!!CharlesGarciaSergeant1984-05-142004-08-06.#!!RobertMillerGeneral1975-03-031999-07-081"!!!JosephGarciaLieutenant1995-06-102019-12-19/!!!DavidWilliamsGeneral1994-03-262015-07-28, !!MichaelSmithMajor1990-08-232011-06-04.!!RichardDavisGeneral1977-09-232002-04-28/!!RichardJonesCorporal1951-04-201971-02-28+!!ThomasJonesMajor1985-02-072006-12-24.!!JamesGarciaSergeant1959-07-201983-01-24/!!JosephJohnsonPrivate1967-09-241990-09-062!!MichaelWilliamsSergeant1980-12-202005-03-26/!!MichaelMillerCaptain1952-09-121973-07-311!!ThomasRodriguezPrivate1986-08-132005-07-29+!!JosephSmithMajor1980-06-242000-03-24-!!JosephSmithCaptain1964-03-031987-03-25.!!WilliamBrownGeneral1980-07-182000-10-18.!!RobertWilsonPrivate1982-05-262006-03-22,!!DavidSmithPrivate1967-05-021988-11-23/!!RichardGarciaGeneral1991-01-112011-04-182!!!MichaelMillerLieutenant1986-05-022006-04-18/!!JosephJohnsonPrivate1970-05-031990-09-06,!!RichardSmithMajor1973-04-191995-02-03/!!WilliamWilliamsMajor1954-02-021977-02-25. !!JohnWilliamsGeneral1988-10-072009-03-14/!!MichaelMillerGeneral1951-12-271974-10-04/!!JamesJohnsonCorporal1988-05-022008-09-27/ !!MichaelMillerGeneral1950-08-221970-10-13/ !!MichaelSmithSergeant1960-01-171981-01-14-!!RobertBrownGeneral1986-05-112006-02-070!!WilliamWilsonCorporal1960-07-111981-04-25-!!JamesGarciaPrivate1962-01-141981-02-232!!CharlesRodriguezGeneral1981-11-112003-03-161!!DavidRodriguezCorporal1952-06-251975-09-25/!!WilliamDavisCorporal1990-05-242013-05-191!!RichardJohnsonSergeant1981-11-022004-02-19,
!!DavidBrownColonel1958-11-241978-05-11 o��l>��}I � � � Z - ��o.d!!JosephGarciaColonel1975-10-271996-01-06/c!!JosephJohnsonColonel1960-06-181983-07-09.b!!JamesGarciaCorporal1971-06-071990-02-02+a!!ThomasDavisMajor1990-06-182012-04-28+`!!RobertSmithMajor1953-05-211977-06-16-_!!DavidWilsonCaptain1959-07-041981-08-30.^!!JamesMillerSergeant1954-04-161972-10-29/]!!JohnWilliamsSergeant1959-03-041982-07-15/\!!!DavidJonesLieutenant1995-07-032016-02-21,[!!MichaelJonesMajor1998-02-152018-03-222Z!!RichardWilliamsCorporal1999-07-272022-03-25/Y!!!JamesDavisLieutenant1956-05-171979-04-062X!!WilliamWilliamsSergeant1975-03-192000-02-14,W!!JamesDavisPrivate1988-08-042013-06-18,V!!DavidBrownPrivate1954-06-271978-10-19,U!!CharlesBrownMajor1967-10-111992-08-060T!!RobertWilliamsGeneral1991-12-262013-02-131S!!RobertWilliamsCorporal1991-03-042011-11-07-R!!JohnMillerCorporal1984-02-092004-06-30 z
����oQ.����nK1 � � � � t Z @ �����_=�����bH% � � � � g D *  � � � � z Y 8 ����xV5����rT6����hG$����yW5����^D# ����sY;����{]C)
�
�
�
}
Z
9
 z
!)
2025-06-30System upgrade y
!'
22024-06-14Routine check!x
!+
2023-09-23Engine overhaul=!w
!+
)2024-10-12Engine overhaul,!v
!+
2024-04-03Engine overhaul!u
!+
22025-06-23Engine overhault
!'
2025-06-14Routine checkQ s
!)
2025-06-04System upgrade?r
!
(2024-07-13Repairq
!
2023-07-24Repair4p
!!
2024-11-12InspectionJo
!!
2023-10-20Inspection^ n
!)
2025-02-06System upgrade%m
!!
2024-07-24Inspectionl
!!
2025-01-21Inspection k
!)
2024-09-15System upgrade@ j
!)
2024-11-25System upgradei
!!
2025-01-01Inspection.h
!
12024-01-11RepairTg
!
2024-10-19Repair_ f
!)
2025-02-13System upgradee
!!
22025-01-03InspectionM d
!)
2024-12-27System upgradeEc
!
!2023-07-30RepairKb
!
22023-11-27Repair/a
!'
02024-08-16Routine check[`
!
02023-10-04Repair/_
!'
2025-05-15Routine check!^
!+
2023-10-31Engine overhaul!]
!+
2023-09-16Engine overhaul9\
!
-2024-08-22RepairZ[
!!
2024-06-22Inspection=Z
!
2025-06-14RepairCY
!!
02024-01-29Inspection^ X
!)
2025-06-13System upgrade; W
!)
*2023-12-06System upgrade@V
!'
2025-05-21Routine check0U
!
2023-09-22RepairWT
!
2024-01-08RepairHS
!
2023-12-09RepairR
!!
2024-12-24InspectionJQ
!!
2024-11-21Inspection`!P
!+
2024-12-25Engine overhaul O
!'
2024-12-11Routine checkXN
!'
2024-09-04Routine checkLM
!'
2024-02-22Routine check2!L
!+
2023-08-18Engine overhaul3!K
!+
-2024-05-21Engine overhaul-!J
!+
2025-01-17Engine overhaul!I
!+
2024-06-10Engine overhaul)H
!!
22025-05-02InspectionaG
!!
2025-02-13Inspection` F
!)
2024-02-15System upgradeRE
!'
2024-06-18Routine checkbD
!'
2024-03-21Routine check@ C
!)
2023-07-08System upgradeB
!
2023-10-18RepairH!A
!+
2024-06-04Engine overhaulP@
!'
(2023-11-20Routine checkW ?
!)
2023-12-11System upgradeJ>
!'
2023-07-19Routine checkH=
!!
*2024-08-28Inspection; <
!)
%2024-07-26System upgrade0 ;
!)
2024-04-19System upgradeb:
!
22023-12-03RepairK!9
!+
2025-04-21Engine overhaul38
!'
2024-11-13Routine check87
!'
)2025-02-15Routine checkH 6
!+ #2023-09-23Engine overhaul5
!
12024-10-29Repair4
!
$2024-04-07RepairY3
!
2025-03-16Repair 2
!)
2025-04-19System upgrade21
!!
2024-04-20Inspection:0
!
!2024-01-24Repair!/
!+
2024-10-21Engine overhaul.
!!
2025-05-04Inspection>!-
!+
2024-04-17Engine overhaul(,
!!
2023-12-28Inspection&+
!!
2023-12-21Inspection !*
!+
.2025-02-27Engine overhaulV)
!!
+2024-11-30Inspection !(
!+
2025-04-18Engine overhaul9'
!
+2024-01-16Repair&
!!
2025-01-02Inspection,!%
!+
2024-06-01Engine overhaul5 $
!)
2024-04-08System upgrade2#
!
2023-09-09Repair"
!!
2025-02-13Inspection!
!!
2024-06-25Inspection. 
!)
2024-03-31System upgrade 
!)
22023-10-07System upgrade_ 
!)
2024-06-09System upgradeH
!'
,2023-08-27Routine checkE
!!
2024-02-24Inspection*
!'
2024-10-22Routine check
!
,2025-02-25RepairL!
!+
2023-10-22Engine overhaul@ 
!)
02024-08-03System upgrade
!
2024-05-30Repair\
!
2025-01-22Repair
!!
22023-12-30Inspectiond
!'
2023-08-26Routine check
!!
2024-10-07Inspection
!'
2024-01-12Routine check
!!
"2024-09-05Inspection 
!'
2023-09-06Routine check
!
2023-09-08Repair!
!+
2023-09-11Engine overhaul[ 
!)
2024-12-15System upgrade=!
!+
2024-05-02Engine overhaula
!!
2024-10-18Inspection\ 
!'
2024-02-20Routine check? 
!)
2023-08-28System upgrade
!
2025-01-29Repair.!
!+
02024-11-11Engine overhaul
!!
2023-09-11InspectionB
!'
2025-02-08Routine check 
!)
2023-12-16System upgrade
!
2025-04-22Repair`
!
2024-09-06RepairJ

!
'2023-08-27Repair@ N]����mR8����{X5 � � � � � b C
���wS4����jH$ � � � � e B '  � � � � q N + ����uZ7����}Z?$���|]�H
!!
2024-06-04Inspection �G
!)
"2025-05-30System upgrade !�F
!+
2024-09-10Engine overhaul'�E
!
2024-12-03Repair�D
!'
2023-10-12Routine check!�C
!+
,2024-11-27Engine overhaulT�B
!
2024-12-19Repair]�A
!
2025-04-26Repair �@
!)
2024-08-11System upgrade-�?
!
-2023-11-09RepairO �>
!)
$2025-03-20System upgrade�=
!'
&2023-07-29Routine checkM�<
!
,2024-07-18Repair!�;
!+
2025-01-15Engine overhaulM�:
!
2025-02-08Repair �9
!)
2024-02-08System upgrade�8
!
2024-02-02Repair �7
!
2024-11-21Repair! �6
!)
2023-07-10System upgrade<�5 !!
2025-01-28Inspectionc�4
!
2023-11-10RepairE!�3
!+
2025-03-25Engine overhaul�2
!
$2024-03-25RepairP �1
!)
2024-02-03System upgrade �0
!)
2023-11-27System upgrade �/
!)
2024-04-15System upgradeU�.
!!
)2024-08-27Inspection�-
!
2024-08-25Repair�,
!!
-2025-05-29Inspection`�+
!
$2024-11-28Repair,�*
!!
2023-09-04Inspectionc�)
!
2024-10-03Repaird �(
!)
2024-12-02System upgraded!�'
!+
2023-10-13Engine overhaul! �&
!)
2025-03-18System upgradeE �%
!)
'2023-09-25System upgrade(�$
!
02023-10-12RepairJ�#
!!
(2025-03-04InspectionN�"
!
22024-04-12RepairB!�!
!+
(2025-05-12Engine overhaul� 
!'
2023-07-14Routine check6 �
!)
2024-06-24System upgraded �
!)
/2023-08-03System upgrade�
!!
2025-03-15Inspection)!�
!+
&2024-03-08Engine overhaulI�
!!
"2024-08-23Inspection?�
!'
*2024-05-04Routine check�
!!
2025-04-28InspectionY!�
!+
2023-09-06Engine overhaul �
!)
2024-01-09System upgrade#�
!'
-2024-03-29Routine check �
!)
%2025-04-18System upgrade �
!'
2024-10-19Routine check_�
!!
2023-12-23InspectionA �
!)
2024-04-25System upgrade�
!!
2023-12-30Inspection=�
!!
2024-07-24InspectionO�
!
22024-10-21RepairJ�
!! 2024-10-14Inspection� 
! 12024-03-15Repair!�
!+
22025-07-03Engine overhaulL�
!'
2023-09-06Routine check7� 
!
"2024-06-02Repair � 
!)
2024-05-19System upgradeF �
!)
+2024-11-05System upgrade�
!!
(2024-02-28Inspection �
!)
"2023-09-04System upgrade&�
!'
2025-04-26Routine check8�
!
2024-12-24Repair �
!)
2025-02-02System upgrade>�
!
12024-10-19RepairZ�

! 2023-10-17Repair�
!
2025-01-11Repair"
!
2023-08-25Repair6~
!!
2024-11-23Inspection=}
!
/2024-01-29Repair!|
!!
2024-05-13Inspection !{
!+
2025-05-18Engine overhaul%